DTS Programming

PackagePassword Property

The PackagePassword property sets or returns the password of the Data Transformation Services (DTS) package to be run by an ExecutePackageTask object.

Applies To

ExecutePackageTask Object

Syntax

object.PackagePassword [= password]

Part	Description
object	Expression that evaluates to an ExecutePackageTask object
password	Owner or user password of the DTS package to be run

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT PackagePassword(BSTR* pRetVal);

HRESULT PackagePassword(BSTR pRetVal);

Remarks

Either the owner or user password can be used to run the package.

This property also can be referenced through the Properties collection of the Task object with the following code:

Set taskprops = task.Properties
taskprops("PackagePassword") [= password]