Automotive Holiday Deals Books Gift Guide Books Gift Guide Shop Women's Cyber Monday Deals Week Learn more nav_sap_SWP_6M_fly_beacon Train egg_2015 Fire TV Stick Beauty Deals Gifts for Her Amazon Gift Card Offer mithc mithc mithc  Amazon Echo Starting at $49.99 Kindle Voyage R6 Siege Outdoor Deals on HTL

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) 1st Edition

12 customer reviews
ISBN-13: 978-1430237716
ISBN-10: 1430237716
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $8.00
Learn More
Trade in now
Have one to sell? Sell on Amazon
Buy new
In Stock.
Ships from and sold by Gift-wrap available.
List Price: $49.99 Save: $3.39 (7%)
22 New from $34.57
SQL Server 2012 Integrati... has been added to your Cart
More Buying Choices
22 New from $34.57 15 Used from $35.57
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get Up to 80% Back Rent Textbooks
$46.60 FREE Shipping. In Stock. Ships from and sold by Gift-wrap available.

Frequently Bought Together

  • SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server)
  • +
  • Professional Microsoft SQL Server 2012 Integration Services
Total price: $78.23
Buy the selected items together

Editorial Reviews

About the Author

Andy Leonard is an SSIS trainer and consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, SQL Server "Most Valuable Professional", blogger, and engineer. He is co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. His background includes web application architecture and development, Visual Basic, ASP, SQL Server Integration Services (SSIS), and data warehouse development using SQL Server 2000, 2005 and 2008.

Matt Masson is a software development engineer working with the SQL Server Integration Services (SSIS) team. Matt has worked on many aspects of the SSIS product including upgrade, performance, and overall user experience. He is a frequent presenter at Microsoft conferences, and maintains the SSIS Team blog ( Prior to joining Microsoft in 2006, Matt was a developer on a number of business intelligence reporting and analytical products. He lives in Montreal, Quebec, and works remotely with his Redmond-based team.

Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer. He has been working with SQL Server for more than eight years, working primarily in business intelligence, ETL/SSIS, database development, and reporting. He has earned a number of industry certifications, holds a bachelor's degree in computer science from Texas A&M University at Commerce, and is a Microsoft SQL Server "Most Valuable Professional". Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area. As an active member of the community, Tim has spoken at venues including numerous SQL Saturday events, Houston Tech Fest, and various user groups and PASS virtual chapters. He is a board member and speaker at the North Texas SQL Server User Group in Dallas, serves as the co-chair of the PASS BI Virtual Chapter, and is an active volunteer for PASS. Tim is an author and forum contributor on and has published dozens of SQL Server training videos on You can visit his website and blog at or follow him on Twitter @Tim_Mitchell.

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft "Most Valuable Professional" of SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, Internet, health services, finance, and energy industries, and has authored technical content for multiple magazines, websites, and the book Microsoft SQL Server 2008 Integration Services: Problem-Design-Solution. Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences. You can read more on her website,

Michelle Ufford is a SQL Server database developer, Integration Services developer, Microsoft SQL Server MVP, and self-proclaimed scripting junkie. She specializes in performance tuning and high-volume VLDB (very large database) development, although her experience also includes database automation, operational predictive analytics, and all stages of the data lifecycle from OLTP to data warehousing. Michelle is an active member of the SQL Server community and a frequent presenter, most notably at PASS Summit. Michelle has a very popular blog at and can be found on Twitter @sqlfool.

Product Details

  • Series: Expert's Voice in SQL Server
  • Paperback: 456 pages
  • Publisher: Apress; 1 edition (September 4, 2012)
  • Language: English
  • ISBN-10: 1430237716
  • ISBN-13: 978-1430237716
  • Product Dimensions: 7.5 x 1 x 9.2 inches
  • Shipping Weight: 2.1 pounds (View shipping rates and policies)
  • Average Customer Review: 3.6 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Best Sellers Rank: #587,300 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

10 of 12 people found the following review helpful By SamV on September 17, 2012
Format: Paperback
This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly talented people we are talking about. Andy is constantly teaching SSIS patterns in his training classes and articles. Matt, for me, is the face of SSIS team at Microsoft. Same goes to other authors, they are common appearances in forums and community events helping people learn SSIS.

Within a few hours of reading this book, it stood out that none of the authors were trying to impress by showing what they all know in SSIS. Instead, they focused on describing solutions and patterns in a great detail (exactly why i paid for).

Each chapter is a collection of solutions and best practices to common data integration problems. For loading flat files go to chapter 7, for data warehouse patterns go to chapter 11. Each solution is written in detail with lots of pictures and step by step instructions. You could have the book open at work and follow through each step to solve a problem without running into any issues.

It is fun to read as well. I smiled when page 30 said VCR play button (referring to the debug button).Literature in the book is plain, clear, and casually written. It was like reading a blog post - simple and refreshing.

If you're on a mission to learn everything about SSIS, this book alone won't probably cut it for you. This isn't a know-all-SSIS book. Authors didn't hide this fact either. Cover of the book says "Improve your efficiency as a data integration developer". This focuses on patterns to data integration problems. If your job involves moving data using SSIS, this is a must have.

SSIS 2012 Design Patterns teaches building faster, efficient, and reusable packages for your data integration needs.

I'm @SamuelVanga on Twitter.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
5 of 5 people found the following review helpful By Brian Alan Carlson on February 22, 2013
Format: Paperback Verified Purchase
What I have read of this book was well written and clear. I have liked books by Andy Leonard in the past, but I was disappointed at the level of the content in this one. It is written more for beginners and the title let me to think it would be at a deeper, more theoretical level. As a seasoned SSIS developer, I didn't find much of the content useful. About the only section that presented new material to me was DQS. Even that section did not add much to what I read on the microsoft website before this book came out.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Update: 6/13/2013
I was contacted by the authors and publisher of this book and advised that the terrible type-setting mentioned in my review and in my uploaded photo only existed in an early batch of books sent to Amazon. The publisher provided me with a replacement free of charge which has none of the previously mentioned problems.

I was greatly impressed by the efforts that the authors and publishers went to in order to track me down and insure my satisfaction.

Rating changed from ** to ***** due to good content and excellent customer service.

Original review:

While the content of the book is fairly good (probably worthy of **** instead of **), the book has horrible text formatting and editing mishaps through out. I'll upload a photo of part of one page so you know I'm not making this up, but here is a text excerpt from Chapter 1 on Metadata Collection:
3. Create a table for each of the data elements we wish to monitor (unused indexes and databaseg rowth).

In Integration Services, we will do the following:
1. Createa n ewI ntegrationS ervicesp ackage.
2. Retrieve a list of SQL Server instances and store the list in a variable.
3. Create an OLE DB connection with a dynamically populated server name.
4. Iteratet hroughe achd atabasea nd
a. Retrievec urrentd atabasea ndl og files izesf orh istoricalm onitoring.
b. Retrieve a list of index candidates for potential redesign or dropping.
c. Update the Last Monitored value for each SQL Server instance.

This is a very flexible model that can easily be expanded to include many more monitoring tasks.
Read more ›
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
2 of 2 people found the following review helpful By Sam1 on December 25, 2014
Format: Paperback Verified Purchase
This book provides many design examples for various typical scenarios any ETL developer will encounter. Personally I was expecting an intermediate-advanced level of content, but this book seems to be targeted more towards beginner-intermediate users. Having tried many ETL designs and solutions previously, I felt this book did not provide enough new content to enlighten me. Still, there are nuggets of useful info throughout the book that makes it worth keeping in my library shelf. Why?

The chapter on BIML alone is worth the price of this book. This is the only book I have come across so far that mentions BIML and provides a thorough walk-through to get you up and running very quickly. BIML is truly game-changing and has saved me hundreds of hours of development time. If you develop many ETLs using the same pattern, I recommend you read the chapter on BIML.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
1 of 1 people found the following review helpful By M Noreen on February 14, 2013
Format: Paperback Verified Purchase
I just received this book and as I skimmed through it, I find myself having a problem with all the typsetting issues. Reading technical documentation takes enough concentration as it is, but to have do the mental gymnastics to sort out letters being smashed into adjacent words, makes it even more difficult. If it was a "product", I'd say it would need to be recalled.
6 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server)
This item: SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server)
Price: $46.60
Ships from and sold by

Want to discover more products? Check out these pages to see more: sql server integration services tuning, cheap accounting software, integration services