The DTS Data Pump is an OLE DB service provider that provides the means to import, export, and transform data between heterogeneous data sources.
The DataPumpTask object contains information about creating and executing an instance of the data pump and is implemented as a custom task.
| DestinationColumnDefinitions Collection | SourceCommandProperties Collection |
| DestinationCommandProperties Collection | Transformations Collection |
| Lookups Collection |
| Execute Method |