DTS Programming

SourceObjectName Property

The SourceObjectName property specifies the source object name if no value for the SourceSQLStatement property is specified.

Applies To
DataDrivenQueryTask Object DataPumpTask2 Object
DataDrivenQueryTask2 Object ParallelDataPumpTask Object
DataPumpTask Object  

Syntax

object.SourceObjectName [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Source object name

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetSourceObjectName(BSTR *pRetVal);

HRESULT SetSourceObjectName(BSTR NewValue);

Remarks

The SourceObjectName property is typically a database table name or worksheet name.

Example

The following code sets the SourceObjectName property:

objDataPump.SourceObjectName = "pubs..authors"


See Also

DestinationObjectName Property

SourceSQLStatement Property