DestinationSQLStatement Property (DTS)

The DestinationSQLStatement property specifies an SQL statement to execute at the data destination.

Applies To

Syntax

object.DestinationSQLStatement [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	SQL statement to execute

Remarks

A DataPumpTask object uses the DestinationSQLStatement property to open a simple rowset on the named destination object (for example, a table or view) if no destination SQL statement is specified. The rowset must support INSERT on the results of a query. A DataDrivenQueryTask object uses the DestinationSQLStatement property to retrieve metadata only, and then immediately closes the rowset.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDestinationSQLStatement(BSTR *pRetVal);

HRESULT SetDestinationSQLStatement(BSTR NewValue);