Professional SQL Server 2000 Dts (Data Transformation Services)

When this book first came out, I grabbed it the first time I saw it on the shelf. We had been using DTS pretty heavily where I worked, but it was all basic stuff. I wanted to dig a little deeper than the basic stuff we were doing and I found this book to be great. I know the reviews on this one are all over the map. However, I found this book to be very useful. If you're doing anything with DTS, you'll want to look through this one.

My company just started using DTS and I needed to learn the technology rapidly. While many Wrox books are 1000+ pages, this book is actually 683. The rest of the pages are devoted to appendixes on the object models.Another strength of this book is the construction of the chapters. After the introductory 2 chapters, the rest can be read in any order or skipped. This book covered many diverse topics, including data warehouse loading, the DTS object model, VBScript, and even using VB to build new custom tasks. The book is primarily focused on DBAs. Therefore, there is more coverage of VBScript and COM object development than a programmer would require. However, given the strong chapter cohesiveness, it is easy to skip this material without missing important information.

I have been working on a project involving DTS and needed a firm grash of it. the book far from scaring me with all the technicalities and programming depth at the begining gradually introduced me to DTS and step by step with example showed me how to harness the power of DTS including the programming side it is the perfect book to introduce you to the subject and for self learner like me it succeed at opening your mind and pointing you to the right direction I 'll recommend it

We've purchased three of these after attending a DTS class for our developers and DBAs. It's a little rudamentary in some of the programming concepts but we bought it more for the DTS functionality end. I loved the case study and the error-handling section was extremely helpful. The book introduces you well to DTS and then proceeds quickly into much more advanced topics. If you don't know programming, the VBScript chapter may be useful. There's a handy reference in the back also to the DTS object model.

This is a very detailed book and answered some specific questions that I had on DTS. Especially in the OLAP portion. Very good level to get you started then moves into the lower level.