SQL Server Integration Services Design Patterns

by Tim Mitchell, Matt Masson, Andy Leonard

SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve common problems encountered when developing data integration solutions. The patterns and solution examples in the book increase your efficiency as an SSIS developer, because you do not have to design and code from scratch with each new problem you face. The book's team of expert authors take you through numerous design patterns that you'll soon be using every day, providing the thought process and technical details needed to support their solutions. SQL Server Integration Services Design Patterns goes beyond the surface of the immediate problems to be solved, delving 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, the book 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, Business Intelligence Markup Language, and Dependency Services.

482 pages, Paperback

First published November 4, 2014

Reviews

[Lolo · Rating 3 out of 5]

This book uses the naming pattern of a book that changed the world in Object Oriented Development (to those who can't make the connection, I'm referring to the GoF book "Design Patterns"). Unfortunately, this book won't change the world of Integration Services.

It's a very good book that explains how SSIS works, but does nothing different than all those other books. I started reading this book expecting to find some genius solutions to problems I've encountered, but no. I found the same old problems and the same old solutions. Don't get me wrong. This book is good compared to other supposed "Professional" SSIS books. This book is INDEED a professional book about SSIS, but that "Design Patterns" title builds a lot of expectations that I was disappointed after reading it.

I would recommend this book to someone that knows the basics of SSIS and needs to know how to apply these basics to real world problems.

[Chris · Rating 5 out of 5]

I wasn’t sure what to think about this book. I have been working with SSIS for 10 years and know it well.

But this book isn’t about just SSIS. It’s about how to use SSIS to creat complete, reliable processes. And how to build frameworks for adding in new processes so that every new thing isn’t built from scratch.

I learned a lot from the book and plan on implementing many of the concepts that the authors laid out. They just make sense.

If you are looking for a book that will guide you in transitioning from a bunch of task-specific packages to an overall, integrated process, this book would be a great resource.