SourceSQLStatement Property (DTS)

The SourceSQLStatement property specifies the SQL statement used to execute on the source rowset.

Applies To
DataDrivenQueryTask 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);

See Also

DestinationSQLStatement Property

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.