Professional SQL Server 2000 DTS (Data Transformation Service)

One of the new outstanding features of SQL Server is Data Transformation Services (DTS). DTS can be used by both developers and database administrators (DBAs) and is attracting a lot of interest. There is a demand for information and currently no other books are available to satisfy this. DTS enables data to be moved between a wide variety of sources and destinations, as well as transforming the data along the way to suit your requirements. DTS can be used to maximum effect in data-driven applications, enabling dynamic data transfer across internet and intranet applications. This offers rapid and effective solutions to common problems such as:

Automatically transferring data into data warehouses
Importing and exporting data to and from other applications for analysis and reporting
Moving working copies of databases between servers

The capabilities of DTS are large and this book will give the reader a complete picture of how to use DTS to its fullest potential.

He also works as a Sr. SQL Server DBA and spends most of his time deep in DTS and SQL Server.

Todd Robinson (MCP, MCP+I, MCP+SB, MCSE, MCSE+I, MCSD, MCDBA, MCT, CCNA) lives in Atlanta, GA where he is an internet application developer and data warehousing guru for Metlife. He specializes in MTS/COM+, ASP, XML, SQL Server and related Windows DNA technologies. In addition to his normal job duties at Metlife, he is President of GradesNow.com an internet application service for teachers, students and parents to allow access to grades online.