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.