Data Formats Supported by DTS

Q

What Are the Data Formats Supported by DTS?

✍: Guest

A

As mentioned in the DTS manual, DTS wizard support many popular data source formats:

  • dBase - *.dbf files created by dBase, a popular database application for PCs.
  • ODBC drivers - Any data source that configured through ODBC drivers.
  • Microsoft Access - *.mdb files created by MS Access.
  • Microsoft Excel - *.xls files created by various versions of MS Excel.
  • Microsoft OLE DB Provider for Oracle - Tables on Oracle server through MS OLE DB driver.
  • Microsoft OLE DB Provider for SQL Server - Tables on SQL Server through MS OLE DB driver.
  • Microsoft Visual FoxPro Driver - Files created by Visual FoxPro.
  • Text File - Text files with rows and columns.

 

SQL Server Connection Tutorials

Defining SQL Server 2005 as the DTS Data Destination

SQL Server FAQs - Introduction to DTS (Data Transformation Services)

⇑⇑ SQL Server Connection Tutorials

2024-01-19, 1224🔥, 0💬