DTS Programming
SourceSQLStatement Property
The SourceSQLStatement property specifies the SQL statement used to execute on the source rowset.
Applies To
| DataDrivenQueryTask Object | DataPumpTask2 Object |
| DataDrivenQueryTask2 Object | ParallelDataPumpTask Object |
| DataPumpTask Object |
Syntax
object.SourceSQLStatement [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | SQL statement used to execute on the source rowset |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetSourceSQLStatement(BSTR *pRetVal);
HRESULT SetSourceSQLStatement(BSTR NewValue);
Remarks
The SQL statement specified by this property can contain ? tokens that are replaced by the values of global variables named by the InputGlobalVariableNames property.