DTS Programming

DestinationSQLStatement Property

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

Applies To

DataDrivenQueryTask Object	DataPumpTask2 Object
DataDrivenQueryTask2 Object	ParallelDataPumpTask Object
DataPumpTask Object

Syntax

object.DestinationSQLStatement [= value]

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

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDestinationSQLStatement(BSTR *pRetVal);

HRESULT SetDestinationSQLStatement(BSTR NewValue);

Remarks

A DataPumpTask object uses the DestinationSQLStatement property to open a rowset on destination connection. If no DestinationSQLStatement is specified, a simple rowset is opened on the named destination object (for example, a table or view). The rowset must support an Insert operation on the results of a query. A DataDrivenQueryTask object uses the DestinationSQLStatement property only to retrieve meta data and then immediately closes the rowset.