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