DTS Programming

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$"