DTS Programming

DataPumpTask Object

The Data Transformation Services (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 makes the features of the data pump available as a DTS task.

Collections
Lookups Collection Transformations Collection
Properties Collection  

Properties
AllowIdentityInserts Property FirstRow Property
Description Property InsertCommitSize Property
DestinationColumnDefinitions Property LastRow Property
DestinationCommandProperties Property MaximumErrorCount Property
DestinationConnectionID Property Name Property
DestinationObjectName Property ProgressRowCount Property
DestinationSQLStatement Property SourceCommandProperties Property
ExceptionFileColumnDelimiter Property SourceConnectionID Property
ExceptionFileName Property SourceObjectName Property
ExceptionFileRowDelimiter Property SourceSQLStatement Property
FastLoadOptions Property UseFastLoad Property
FetchBufferSize Property  

Methods
Execute Method