Microsoft® SQL Server 2000 DTS Step by Step Carl Rabelel PDF

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.