Data Transformation Services API
The Data Transformation Services (DTS) application programming interface (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 Automation or COM:
- DTS transfers data between heterogeneous OLE DB data sources.
- DTS performs customized transformations that can convert detailed online transaction processing (OLTP) data to a summarized form for easy analysis of trend information.