Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS) and began writing his own motion data applicationsone step at a time. This practical, hands-on tutorial guides you through the expert application development DTS that extract and transform data from the database into a data warehouse. And accelerate your productivity by working with instructive code examples and best practices for SQL Server 2000 DTS. Discover how to: Create simple data movement packages with the DTS Import / Export Wizard Create complex data movement application with the DTS Designer that configures pre-built flexibility of the DTS task Exploit Data Driven Query (DDQ) task without sacrificing performance Entering execution logic, flow control, branching, control transactions , and parallel execution into DTS packages and tasks dynamically configure DTS packages and tasks at run time Save DTS packages in SQL Server, Meta Data Services, Structured Storage, and Microsoft Visual Basic Extract the file format and transform heterogeneous data using ActiveX Scripts Integrate customized logging , error handling, and batch control into your application Develop and operate a data movement application About DTS in SQL Server 2000: Microsoft SQL Server 2000 Data Transformation Services (DTS) provides a set of graphical tools and programmable objects to extract, transform, and consolidate data from different sources into single or dual purpose. By using DTS tools, you can create custom solutions to data movement to support decision-making, improve system performance, upgrade existing systems, and more.