DTS Programming

Name Property

The Name property specifies the name of a Data Transformation Services (DTS) object.

Applies To

ActiveScriptTask Object	OLEDBProviderInfo Object
BulkInsertTask Object	Package Object
Column Object	Package2 Object
Connection Object	PackageInfo Object
Connection2 Object	PackageLineage Object
CreateProcessTask Object	PackageLogRecord Object
CreateProcessTask2 Object	PackageRepository Object
CustomTask Object	PackageSQLServer Object
DataDrivenQueryTask Object	ParallelDataPumpTask Object
DataDrivenQueryTask2 Object	Property Object
DataPumpTask Object	ScriptingLanguageInfo Object
DataPumpTask2 Object	SendMailTask Object
DTSFTPTask Object	Step Object
DTSMessageQueueTask Object	Step2 Object
DynamicPropertiesTask Object	StepLineage Object
ExecutePackageTask Object	StepLogRecord Object
ExecuteSQLTask Object	Task Object
ExecuteSQLTask2 Object	TaskInfo Object
GlobalVariable Object	TransferObjectsTask Object
GlobalVariable2 Object	TransferObjectsTask2 Object
Lookup Object	Transformation Object
OLEDBProperty Object	Transformation2 Object
OLEDBProperty2 Object	TransformationSet Object

Syntax

object.Name [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Name of a DTS object

Data Type

Object

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetName(BSTR *pRetVal);

HRESULT SetName(BSTR NewValue);

Remarks

Name is a unique, user-defined text label for a Package2 object. When saved to an instance of Microsoft® SQL Server™ or SQL Server 2000 Meta Data Services, this name is used as a primary key.

A nonempty value for the Name property is required for most other DTS objects, as well.