Export (0) Print
Expand All

Usage Considerations in DTS

SQL Server 2000

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft