DTS Goals

DTS was created to:

• Provide better importing, exporting, and transformation of heterogeneous data using OLE DB.
• Provide an extensible architecture accessible to ISVs, customers, and consultants.
• Share rich metadata about the sources, destinations, transformations, and lineage through integration with Microsoft Repository OIMs.

DTS allows the user to import, export, and transform data to and from multiple data sources using 100 percent OLE DB–based architecture. OLE DB data sources include not only database systems, but also desktop applications such as Microsoft Excel. Microsoft provides native OLE DB interfaces for SQL Server and for Oracle. In addition, Microsoft has developed an OLE DB wrapper that works in conjunction with existing ODBC drivers to provide access to other relational sources. Delimited and fixed-field text files are also supported natively.