the initial check nearly two dozen built-in tasks or functions in DTS - from the obvious (copying data from one database to another) to more esoteric (sending files via FTP within DTS). A gentle introduction to using VBScript objects and ActiveX to get the DTS object model to design a "special duty." Then, there is an excellent tutorial on data warehousing, done the Microsoft way - from the basics of snowflakes, stars, and hybrid fact tables for the data mart to setting up and loading data using DTS, and then run the database with Microsoft Analysis Services . The book concludes with a comprehensive reference section that lists the objects and methods in the DTS object model. Did you do a normal database administration or setting up a data warehouse - or you just want to work with data more effectively in your application - Professional SQL Server 2000 DTS provides all the information you need to become productive with a strong (and sometimes overlooked) set Dragan database tools and components. - Richard Topics covered: Introduction to Data Transformation Services (DTS) DTS wizards and tools Surveying The Import / Export Wizard Copy Database Wizard DTS Designer Survey of automated tasks in SQL Server 2000, including the Bulk Insert, Execute SQL, Copy SQL Server Objects, and Transfer Databases tasks This multiphase Data Pump Use Data Driven Query (DDQ) Execute Package Task FTP Task The Message Queue Task Advanced General package properties option package Transfer Data Task options scrubbing Data Working with heterogeneous data (using a server to connect from the mainframe and legacy servers) Tips for converting data Excel and DB2 DTS ActiveX Script Quick basic tutorial for VBScript syntax The DTS Object Model Management DTS FileSystemObject object files with a security problem Meta Data Services Back up a database error handling Building custom tasks in DTS DTS Star, snowflake, and hybrid designs for data warehouse Extract , Transformation, and Load (ETL) with DTS Microsoft Analysis Services Creating Web front ends for DTS applications references to the DTS and ADO object model references essential VB functions and keywords Microsoft Scripting Run-Time Reference