Data Transformation Services API

The Data Transformation Services (DTS) API is a set of objects encapsulating services that assist with building a data warehouse. DTS can be used in applications written in languages that support OLE Automation or COM. DTS:

• Transfers data between heterogeneous OLE DB data sources.
• Performs customized transformations that can convert detailed online transaction processing (OLTP) data to a summarized form for easy analysis of trend information.

See Also