Microsoft SQL Server 2000 Data Transformation Services (DTS) 

CONTENTS

Part I - Getting Started with DTS
1 - A Quick Look at DTS
2 - DTS Enhancements for SQL Server 2000 
3 - DTS and the Flow of Data Through the Enterprise
4 - Using DTS to Move Data into a Data Mart

Part II - DTS Connections and the Data Transformation Tasks
5. DTS Connections
6. The Transform Data Task
7. Writing ActiveX Scripts for a Transform Data Task
8. The Data Driven Query Task
9. The Multi-Phase Data Pump
10. The Parallel Data Pump Task

Part III - Other Data Movement Tasks
11. The Bulk Insert Task
12. The Execute SQL Task
13. Copy SQL Server Objects Tasks
14. The File Transfer Protocol (FTP) Task
15. The Transfer Database and Other Transfer Tasks

Part IV. Control Tasks
16. Writing Scripts for an ActiveX Script Task
17. The Dynamic Properties Task
18. The Execute Package Task
19. The Message Queue Task
20. The Send Mail Task
21. The Analysis Services Tasks
22. The Execute Process Task

Part V. DTS Packages and Steps
23. The DTS Package and its Properties
24. Steps and Precedence Constraints
25. Rapid Development with the Copy Database Wizard and the DTS Import/Export Wizard
26. Managing Packages with Visual Basic
27. Handling Errors in a Package and its Transformations
28. High Performance DTS Packages
29. Integrating DTS with Meta Data Services

Part VI Extending the Power of DTS
30. Programming with the DTS Object Model
31. Creating a Custom Task with VB
32. Creating a Custom Transformation with VC++

sdg