on 26 June 2007
This book suffers from the problem of being written by too many authors who obviously didn't take the trouble to talk to one another. It is poorly structured and repetitive, so it works neither as a tutorial or reference. Most of the information here could have been gleaned from Books Online (and that's no compliment to any SQL book). It would have been really nice if the book started at the beginning, covered the detail in the middle, and ended at the end - instead it thrown random bits of semi-useful data about in a haphazard manner.
The only redeeming feature is the (convoluted) case study at the back which gives context to SSIS (as opposed to the T-SQL alternative I'm likely to be sticking to for the time being).
This isn't awful but it could have been so much better.
on 5 March 2007
This book provides a good deal of insight into SSIS, Microsofts ETL tool bundled with SQL Server 2005. Anyone who works with SSIS knows how frustrating it can be to work with and the various authors include solutions / workarounds to most of most annoying features of the software. After reading the book, you are left wanting more - an 'Expert' version is in the pipeline. Note that some of the examples do not work. However, you can go to the Wrox for working versions