Data Transformation Services (DTS) are the data-manipulation utility services in SQL Server version 7.0 that provide import, export, and data-manipulating services between OLE DB, ODBC, and ASCII data stores. This white paper describes how to expand DTS by interacting with it through its native COM interface.

Included in this document:

• DTS Object Model
• Transformations
• The Interfaces
• Implementing a Solution for Data Mart Population