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]