The Transform Data task is the primary mechanism by which you move and transform data from one connection to another in DTS Designer.
The Transform Data task refers to an instance of the DTS Data Pump, an OLE DB service provider that provides the means to import, export, and transform data between heterogeneous data sources.
The Transform Data task is designed to interact with a source rowset and move the data into a destination rowset. It requires two or more connections. As it moves data from the source to destination, it exposes the transformations.
After adding a Transform Data task between two data source connections, you configure the Transform Data task by setting its properties. You can also set these advanced options:
Note You must add data source connections to the DTS Designer workspace and configure their connections before adding and configuring a Transform Data task.