ExecuteSQLTask2 Object

DTS Programming

DTS Programming

ExecuteSQLTask2 Object

The ExecuteSQLTask2 object allows you to execute a sequence of one or more SQL statements on a connection.

Extended Properties
InputGlobalVariableNames Property OutputGlobalVariableNames Property
OutputAsRecordset Property  
Remarks

The ExecuteSQLTask2 object extends the functionality of the ExecuteSQLTask object and inherits the properties and methods of that object. In addition, the ExecuteSQLTask2 adds the InputGlobalVariableNames, OutputAsRecordset and OutputGlobalVariableNames properties.

The InputGlobalVariableNames property specifies a list of Data Transformation Services (DTS) global variable names that are used as parameters for the sequence of SQL statements specified by the SQLStatement property. The OutputGlobalVariableNames property specifies a list of global variable names that receive fields from the first row of the first rowset produced by the SQLStatement query. If the OutputAsRecordset property is set, the entire rowset is written to the first global variable specified by OutputGlobalVariableNames as a disconnected Microsoft® ActiveX® Data Objects (ADO) recordset.

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

See Also

ExecuteSQLTask Object

SQLStatement Property