Chapter 13. Data Transformation Services
by Mark Spenik
IN THIS CHAPTER
DTS and the Data Warehouse
DTS and OLE DB/ODBC
The DTS Framework
Using the DTS Wizard
Using the DTS Designer
What Are Workflow and Batch Processing?
Using DTS Packages
Data Transformation Services FAQ
Just about everyone who has interacted with SQL Server in the past has had to either import data into or export data out of it. This task has proven to be cumbersome and complex. BCP, SQL server's tried-and-true command-line data pump has probably caused a headache or two for most DBAs. Whenever the need arises to import a large amount of information, most people once again look to the help files to figure out how to construct the dreaded format file or try and find a developer to ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.