Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution (Wrox Programmer to Programmer)

An authoritative guide to designing effective solutions for data cleansing, ETL, and file management with SQL Server 2008 Integration Services

SQL Server Integration Services (SSIS) is the leading tool in the data warehouse industry, used for performing extraction, transformation, and load operations.

After an overview of SSIS architecture, the authors walk you a series of real-world problems and show various techniques for handling them.

Shows you how to design SSIS solutions for data cleansing, ETL and file management
Demonstrates how to integrate data from a variety of data sources,
Shows how to monitor SSIS performance,
Demonstrates how to avoid common pitfalls involved with SSIS deployment
Explains how to ensure performance of the deployed solution and effectively handle unexpected system failures and outages
The companion Web site provides sample code and database scripts that readers can directly implement

This book shows you how to design, build, deploy, and manage solutions to real-world problems that SSIS administrators and developers face day-to-day.

Customer Reviews:

SQL Server Integration Services: Problem - Design - Solution

By Tim D. Mitchell "tdmitch" - April 15, 2010

I usually don't do book reviews (at least publicly, anyway), but when I find a piece of work that I really get a lot out of, I don't mind sharing my experience. Such was the case with a book I finished recently. SQL Server 2008 Integration Services: Problem - Design - Solution is a concise guide to becoming a better ETL developer, written by four highly experienced industry experts. After reading this book, I can recommend it without hesitation!

From the first few pages, it's obvious that this book is different from many other SSIS books. Rather than trying to teach the reader how to use the software, this book instead focuses on common business problems and the methodology behind solving them. The authors assume some familiarity with SSIS, so you won't find a comprehensive how-to manual if you've never created a package before. That being said, the concepts presented here are not so complex that only highly seasoned ETL developers will understand them; to the... read more

A treasury of ETL best practices in action.

By Shabnam Watson - February 16, 2010

This book is a treasury for ETL developers / architects. It is very different from other ETL books in the way that it is written with a top-to-bottom approach instead of focusing on details of an ETL tool. Each chapter presents a problem that an ETL developer/architect will face during a real project. Then it provides design ideas and best practices for the problem and finally delivers a solution that can be implemented. The collection of design ideas, best practices and solutions provided is priceless. The solutions are ready for use or require minimal change and presented in enough details for someone who is familiar with SSIS. This is the book you want to have if you want to know how the SSIS experts would solve the ETL problems you are facing.

The only chapter that falls short in comparison with others in terms of the quality of the solution provided is chapter 9 on SSAS processing. The information is useful and written with the same format of other chapters but is not... read more

Advanced SSIS, Thank You!

By J. Cooke - March 23, 2010

This book is really good for more advanced users. If you have developed SSIS packages in the past, and want to take the next step to make your systems better, then get this book. I am a developer for a big company and I rarely see advanced "real world" examples of SSIS solutions. I love the first chapter on SSIS logging. Download the code from the website, and it will create your logging tables and procs with just minor modifications to the scripts.

I initially put off buying this book for a week because it only had one review at the time (even though it was 5 stars).
This is an excellent Book!