Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution 1st (first) Edition by Veerman, Erik, Moss, Jessica M., Knight, Brian, Hackney, Jay published by Wrox
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.