Your hands-on, self-study guide to developing applications using SQL Server 2000 Transformation Services 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.

Contents

• Introduction
• Jumping into DTS
• Using DTS designer to build and extend packages
• Working with DTS packages
• Creating advanced DTS tasks
• Working with advanced DTS options
• Dynamically configuring DTS package objects
• Using ActiveX script tasks
• Incorporating error handling into DTS packages
• Completing the data movement application
• Operating the data movement application

• Index