Data Transformation Services

Data Transformation Services (DTS) makes it easy to import, export, and transform data between multiple heterogeneous data sources using an OLE DB-based architecture. DTS allows you to move and transform data to and from:

• Native OLE DB providers such as SQL Server, Excel, Microsoft Works, and Access.
• ODBC data sources such as Access, Oracle, and DB2 using the OLE DB Provider for ODBC.
• ASCII fixed-field length text files and ASCII-delimited text files.