Microsoft SQL Server 2000 DTS [Data Transformation Services]

Microsoft SQL Server 2000 Data Transformation Services covers all facets in the development of data transformations with DTS. The reader will learn how to create each of the DTS tasks, both in the User Interface supplied with SQL Server and through the object model using Visual Basic or VBScript.

Microsoft SQL Server 2000 Data Transformation Services is filled with numerous small examples, showing how each of the capabilities of DTS can be used. It also includes a number of Data Transformation Templates, which can be used by the readers to help develop their own packages.

Customer Reviews:

Thorough look at all of the DTS packages

By Douglas Welzel - May 14, 2001

SQL Server DTS gives a very good review all the DTS packages available in SQL Server 2000. Each package is presented with an overview of it's features, a dicussion of the package options and examples of using the package. In most cases, there are nice examples of how to use (and extend) the package programmatically (using Visual Basic).The book is useful beyond learning about DTS because it explains how to use DTS effectively. The book frequently comments on performance implications of certain features and gives the tradeoffs between certain packages.If there is a downside, it is that the book doesn't cover the DTS object model too well. The code examples are very good, but if you want to delve deeper you'll find yourself sifting through the DTS online documentation. However, I'm not sure this is a downside. Leaving this information out allows the book to stay on topic without drifting off into reference material.Overall a very good both for those looking to learn about... read more

Complete and Useful reference for DTS.

By Guillermo F. Salas - March 14, 2003

SQL Server 2000 DTS by Peterson.As much as DTS is used in the thousands of SQL Server (7 & 2000) implementations out there, for tasks as simple as copying or moving tables from one database to another, there is VERY little documentation on the product... that is, documentation that explores and explains the details and myriad of options available for use within the tool. I am a strong believer that because of this lack of documentation this wonderful tool is underutilized and regarded as a mystery to many.Here comes Mr. Peterson and gives us this great resource to help us better understand the intricacies of the tool, in a very logical and organized manner with the respect and level of content that a professional (such as is the target audience for this book) needs and appreciates.Chapters are specific, to the point and generally develop some sort of simple scenario that puts the theory into practice. The author constantly points out the areas where the 2000 version of... read more

Great overview- great reference

By Darta - June 27, 2001

I liked the book. It has helped me in any DTS task I undertake. The book gives you everything you need to perform DTS manipulation. Like every book, it cannot provide you with "everything". Therefore, for starters, try this book to give you the knowledge that you need to be a DTS power user. Then supply it with deja.com groups, MDSN and Books Online if needed. There is no need to buy any other book.