DestinationObjectName Property
The DestinationObjectName property specifies the name of a data destination.
Applies To
| DataDrivenQueryTask Object | DataPumpTask2 Object |
| DataDrivenQueryTask2 Object | ParallelDataPumpTask Object |
| DataPumpTask Object | Â |
Syntax
object.DestinationObjectName [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Name of a data destination |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetDestinationObjectName(BSTR *pRetVal);
HRESULT SetDestinationObjectName(BSTR NewValue);
Remarks
Typically, a DestinationObjectName is a database table or view name or a Microsoft® Excel worksheet name.
A DataPumpTask2 object uses the DestinationObjectName property to open a simple rowset on the named destination object if nothing is specified for the DestinationSQLStatement property. A DataDrivenQueryTask2 object uses the DestinationObjectName property only to retrieve meta data and then releases the rowset.
Example
The following code illustrates how to specify a database table for the destination object name:
objDataPump.DestinationObjectName = "pubs.dbo.authors"
The following code illustrates how to specify an Excel worksheet for the destination object name:
objDataPump.DestinationObjectName = "DailyReport$"