An authoritative guide to designing effective solutions for datacleansing, ETL, and file management with SQL Server 2008Integration Services SQL Server Integration Services (SSIS) is the leading tool inthe data warehouse industry, used for performing extraction,transformation, and load operations. After an overview of SSIS architecture, the authors walk you aseries of real-world problems and show various techniques forhandling them. This book shows you how to design, build, deploy, and managesolutions to real-world problems that SSIS administrators anddevelopers face day-to-day.
Even though this book is currently outdated, it's so well written that still remains relevant. I've read that book in the past, but only now that I'm more experienced in real life problems I can appreciate the value.
The concepts are so well thought and developed. The designs and solutions are so advanced and very useful in real world scenarios.
This is and advanced/expert book and I would highly recommend it to anyone experienced in SSIS and Data Warehouse design that wants to learn and develop new skills.
An excellent book about how to use SSIS to optimally solve many problems that may be encountered when developing a data warehouse. Furthermore, a chapter is dedicated to the implementation of a SSIS management framework which the code (package, T-SQL, etc.) can be easily reused. The source code examples are all downloadable.