Microsoft SQL Server 2000 DTS [Data Transformation Services]

by Timothy Peterson

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.

744 pages, Paperback

First published December 12, 2000

About the author

Timothy Peterson is the chief consultant at SDG Computing, Inc., a company specializing in data warehousing with Microsoft's SQL Server tools. He teaches the Microsoft Data Warehousing course and customized DTS and OLAP courses for Mindsharp Learning Centers in Bloomington, MN. He has used DTS in SQL Server 7.0 for data warehousing projects with telecommunications, insurance, manufacturing, and internet companies.