Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

SQL Server 2012 Integration Services Design Patterns [Kindle Edition]

Tim Mitchell , Andy Leonard , Matt Masson , Jessica Moss , Michelle Ufford
3.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £39.50
Kindle Price: £31.60 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £7.90 (20%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £31.60  
Paperback £39.50  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution.

SQL Server 2012 Integration Services Design Patterns does not focus on the problems to be solved; instead, the book delves into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, SQL Server 2012 Integration Services Design Patterns provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, and Dependency Services.

  • Takes you through solutions to several common data integration challenges
  • Demonstrates new features in SQL Server 2012 Integration Services
  • Teaches SSIS using practical examples

What you’ll learn

  • Load data from flat file formats
  • Explore patterns for executing SSIS packages
  • Discover a pattern for loading XML data
  • Migrate SSIS packages through your application lifecycle without editing connections
  • Take advantage of SSIS 2012 Dependency Services
  • Build an SSIS Framework to support your application needs

Who this book is for

SQL Server 2012 Integration Services Design Patterns is for the data integration developer who is ready to take their SQL Server Integration Services (SSIS) skills to a more efficient level. It’s for the developer interested in locating a previously-tested solution quickly. SQL Server 2012 Integration Services Design Patterns is a great book for ETL (extract, transform, and load) specialists and those seeking practical uses for new features in SQL Server 2012 Integration Services. It’s an excellent choice for business intelligence and data warehouse developers.

Table of Contents

  1. Metadata Collection
  2. Execution Operations
  3. Scripting
  4. SQL Server Source Patterns
  5. Data Cleansing
  6. DB2 Source
  7. Flat File Source Patterns
  8. Parallel Data Warehouse
  9. XML
  10. Expression Language Patterns
  11. Data Warehouse
  12. Logging
  13. Slowly Changing Dimensions
  14. Loading the Cloud
  15. Reporting
  16. Parent-Child Patterns
  17. BIML
  18. Configuration
  19. Deployment
  20. Estimating ETL Projects

Product Description

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.

Product details

  • Format: Kindle Edition
  • File Size: 11811 KB
  • Print Length: 458 pages
  • Page Numbers Source ISBN: 1430237716
  • Publisher: Apress; 1 edition (5 Sept. 2012)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00992OBHS
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #366,002 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

5 star
4 star
2 star
1 star
3.0 out of 5 stars
3.0 out of 5 stars
Most Helpful Customer Reviews
3 of 3 people found the following review helpful
Format:Paperback|Verified Purchase
I had pre-ordered this book because I was extremely interested by the idea of "Design Patterns" within an SSIS environment.

I must say I am very disappointed by the end product.
I am still not clear whether the book is an introduction to the new features in SSIS 2012 or whether it is about Design Patterns.
It seems to float from chapter to chapter somewhere in between.

I found the early chapters extremely poor.

It started well with an interesting chapter 1 about how to collect various data from several servers.
The Pattern was clearly introduced so that I had a good idea before diving in the details.
It was easy to read and instructive. Job well done.

Then came chapter 2...
I might be slightly daft but it is still not clear to me where the pattern is supposed to be... or what this was supposed to achieve.
It seems to assume knowledge of the new mode of Deployment/Execution offered by SQL 2012 and does not explain why we need to improve on it...
What's wrong with firing SSIS Packages from SQL Server Agent? No idea...

So I read about 40 pages of detailed stored procedure code with no idea what it was trying to achieve.
If you are patient enough, you will find the required explanations about the new deployment and execution tools in chapters 18 & 19... but I did not have the courage to re-read chapter 2 to see if it made more sense afterwards.

I found this lack of "Design Pattern" up to and including chapter 6.

After that, it becomes more interesting but still I regret, in many instances (not all chapters), the lack of an overall pattern description before diving in the details.
This forces you to read an entire chapter before knowing whether it is actually useful to you.
Read more ›
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.5 out of 5 stars  11 reviews
10 of 12 people found the following review helpful
4.0 out of 5 stars Straight to the point. Problem. Solution - Excellent resource for ETL developers. 18 Sept. 2012
By SamV - Published on
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.
5 of 5 people found the following review helpful
3.0 out of 5 stars Not what I expected 22 Feb. 2013
By Brian Alan Carlson - Published on
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.
5 of 6 people found the following review helpful
5.0 out of 5 stars If you have a copy with bad typset problems contact Amazon Customer Service or APress for a replacement. 15 Feb. 2013
By Amazon Customer - Published on
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. A screenshot of the completed package is displayed in Figure 1-1.
Fortunately, my staff are all fairly adept at reading Klingon and have been able to work their way through this, but they should not have to spend time translating when they are reading a $40 technical book. I agree whole heartedly with M Noreen's review. The book should be recalled by the publisher and buyers of this book should receive a refund.
2 of 2 people found the following review helpful
4.0 out of 5 stars The chapter on BIML alone is worth the price of this book 25 Dec. 2014
By Sam1 - Published on
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.
1 of 1 people found the following review helpful
3.0 out of 5 stars Typesetting issues 14 Feb. 2013
By M Noreen - Published on
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.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category