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.
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. Tim was the lead author of Microsoft OLAP Unleashed, published by SAMS in 1999.