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.