Programming Books C Java PHP Python Learn more Browse Programming Books
SQL Server 2012 Integration Services Design Patterns and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $49.99
  • Save: $9.81 (20%)
Only 1 left in stock (more on the way).
Ships from and sold by
Gift-wrap available.
Condition: Used: Very Good
Comment: 100% Guaranteed. Small tear to back cover. Moderate shelf wear due to handling. Pages are clean and unmarked.
Access codes and supplements are not guaranteed with used items.
Sell yours for a Gift Card
We'll buy it for $17.12
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) Paperback – September 5, 2012

ISBN-13: 978-1430237716 ISBN-10: 1430237716 Edition: 1st

Buy New
Price: $40.18
24 New from $25.00 11 Used from $32.17
Amazon Price New from Used from
"Please retry"
"Please retry"
$25.00 $32.17

Frequently Bought Together

SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) + Professional Microsoft SQL Server 2012 Integration Services
Price for both: $75.40

Buy the selected items together

Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

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

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.

More About the Authors

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

Customer Reviews

3.3 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 11 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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Jo Inge Stubbe on November 3, 2012
Format: Kindle Edition Verified Purchase
Give ac lot of examples with pro and cons for each practice. Loveed the blog style it's written, easy and interesting
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again