DataDrivenQueryTask2 Object

DTS Programming

DTS Programming

DataDrivenQueryTask2 Object

The DataDrivenQueryTask2 object transforms data from a source connection and invokes user-defined queries to write data to a destination connection.

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

The DataDrivenQueryTask2 object extends the functionality of the DataDrivenQueryTask 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 DataDrivenQueryTask object instead of the DataDrivenQueryTask2 object, see Extended DTS Objects.

See Also

DataDrivenQueryTask Object

SourceSQLStatement Property