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.