Teach yourself the full range of capabilities of SQL Server 2000 Data Transformation Services (DTS) one step at a time! This practical hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through easy-to-follow lessons and hands-on exercises to learn essential techniques for performing basic and advanced tasks and for creating custom tasks. You'll learn how to work with heterogeneous data sources to extract transform and consolidate data using ActiveX® scripts. And you'll learn how to incorporate execution logic flow control looping transaction control logging error handling and security into DTS packages. When you complete the step-by-step lessons you'll have built a full data movement application.