DTS Programming
SQLStatement Property
The SQLStatement property specifies a sequence of one or more SQL statements or stored procedure references to be executed.
Applies To
| ExecuteSQLTask Object | ExecuteSQLTask2 Object |
Syntax
object.SQLStatement [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Query that is a sequence of one or more SQL statements or stored procedure references |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetSQLStatement(BSTR *pRetVal);
HRESULT SetSQLStatement(BSTR NewValue);
Remarks
In the ExecuteSQLTask2 object, the SQLStatement query can contain ? tokens that are replaced by the values of global variables specified by the InputGlobalVariableNames property. Fields from the first row of the rowset generated by the query are assigned to the global variables specified by the OutputGlobalVariableNames property. The entire rowset can be written to a global variable as a disconnected Microsoft® ActiveX® Data Objects (ADO) recordset if the OutputAsRecordset property is set.