Data Transformation Services
DTS Driver Support for Heterogeneous Data Types
Data Transformation Services (DTS) uses the ODBC drivers and OLE DB providers supplied by Microsoft® SQL Server™ 2000 to perform distributed operations against heterogeneous data sources.
The following table summarizes, for each of the major data sources, those supplied drivers or providers. Microsoft Product Support Services will help you resolve problems that you encounter when using these drivers and providers to perform distributed operations. If you are using another driver or provider, contact the vendor of that ODBC driver or OLE DB provider for support.
| Data source | Driver or provider | Supported |
|---|---|---|
| Oracle 8 | Microsoft ODBC for Oracle version 2.573.3401.00 | Yes |
| Oracle 8 | Microsoft OLE DB Provider for Oracle version 2.0010.3401.000 | Yes |
| Microsoft Jet version 4.0 | Microsoft OLE DB Provider for Jet version 4.0000.2115.0004 | Yes |
| Microsoft Excel spreadsheet | Microsoft OLE DB Provider for Jet version 4.00.2115.15 | Yes |
| Microsoft Jet version 3.51 | Microsoft Access Driver version 4.00.3401.00 | No |
| IBM DB2/MVS | StarSQL 32 version 2.52.0501 | Yes |
| IBM DB2/AS400 | StarSQL 32 version 2.40.0805 | Yes |
DTS and Informix
- The Informix ODBC driver is not supported for use with DTS.
- The Merant Informix OLE DB provider is supported for DTS imports from Informix, but not DTS exports to Informix. This driver also cannot be used to import meta data.
- The Intersolv Informix ODBC driver is supported, but with the following restrictions:
- BLOBs cannot be exported to Informix.
- When creating new tables on Informix, the DTS Import/Export Wizard will incorrectly map the SQL Server 2000 datetime columns to the Informix 'Datetime year to fraction' data type. Manually change this to the Informix Date type.
- The DTS meta data import will not import Informix catalog or table information.
- BLOBs cannot be exported to Informix.