Data Transformation Services
Usage Considerations in DTS
This section describes specific data conversion and data transformation issues that may arise when using Data Transformation Services (DTS) and supplies additional DTS error information.
| Topic | Description |
|---|---|
| Enhancing Performance of DTS Packages | Describes ways to enhance the performance of DTS packages. |
| Data Conversion and Transformation Considerations | Details the interactions between individual providers and DTS. |
| DTS Driver Support for Heterogeneous Data Types | Lists the ODBC drivers and OLE DB providers supplied by SQL Server to perform distributed operations against heterogeneous data sources. |
| Enhancing Data Driven Queries in DTS | Describes error handling issues, and issues regarding the use of transactions, lookups, and connections with a Data Driven Query task. |
| Enhancing Lookup Queries in DTS | Lists issues and implementation details you should consider when using lookup queries in a DTS package. |