DataPumpTask2 Object

DTS Programming

DTS Programming

DataPumpTask2 Object

The DataPumpTask2 object imports, exports, and transforms data between heterogeneous data sources.

Extended Properties
DataPumpOptions Property InputGlobalVariableNames Property
ExceptionFileOptions Property RowsComplete Property
ExceptionFileTextQualifier Property  
Remarks

The DataPumpTask2 object extends the functionality of the DataPumpTask object and inherits the properties and methods of that object. In addition, Microsoft® SQL Server™ 2000 provides the following properties:

  • The ExceptionFileOptions property specifies how errors and exception rows are to be written to the appropriate files. The ExceptionFileTextQualifier property specifies the text qualifier for the data in the exception file.

  • The SourceSQLStatement property specifies parameters that can now be coded in the query. The InputGlobalVariableNames property specifies a list of package global variable names whose values are to be substituted for the query parameters.

  • The RowsComplete property returns the count of transformed rows and the RowsInError property returns the number of transformation error rows.

For more information about when to use the DataPumpTask object instead of the DataPumpTask2 object, see Extended DTS Objects.

See Also

DataPumpTask Object

SourceSQLStatement Property