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. |