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.