DTS Programming
OutputAsRecordset Property
The OutputAsRecordset property returns or specifies whether the entire rowset generated by the Execute SQL task query should be stored in a global variable.
Applies To
| ExecuteSQLTask2 Object |
Syntax
object.OutputAsRecordset [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an ExecuteSQLTask2 object |
| value | Whether the entire rowset should be stored in a global variable |
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetOutputAsRecordset(VARIANT_BOOL *pRetVal);
HRESULT SetOutputAsRecordset(VARIANT_BOOL NewValue);
Remarks
The rowset is placed in the first named global variable in the OutputGlobalVariableNames list as a disconnected Microsoft® ActiveX® Data Objects (ADO) recordset. The variable is set to Nothing if no rowset is returned from the query.