6 of 6 people found the following review helpful
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.
1 of 1 people found the following review helpful
With the release of SQL Server 2005 Microsoft completely redeveloped DTS and renamed it Integration Services. This book provides a superb guide to using this new technology showing you how to easily transform data and interact with web services from within SQL Server.
Whilst this book does suffer slightly from `too many author syndrome' it still is easily readable and can act as a great reference book for those of us who don't work every day with this technology but need it every now and again as part of a development project.
4 of 5 people found the following review helpful
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