INF: Leveraging the Power of DTS (White Paper) (322702)
The information in this article applies to:
This article was previously published under Q322702 SUMMARY
Data Transformation Services (DTS) are data-manipulation utility services in SQL Server 7.0 that provide import, export, and data-manipulating services between OLE DB, ODBC, and ASCII data stores. To view a white paper that describes how you can interact with DTS through its native COM interface, visit the following Microsoft Web site:
Included in this document:
- Adding a DataPump Task
- Adding a CopyColumn Transformation
- Adding a Column
- Adding an ActiveXScriptTransformation
- Adding a DataDrivenQueryTask
- Adding Steps
- Adding Constraints
- Putting the Pieces Together
| Modification Type: | Major | Last Reviewed: | 6/5/2002 |
|---|
| Keywords: | kbinfo kbwhitepaper KB322702 |
|---|
|