DTSPackagePassword Property (Replication ActiveX)

The DTSPackagePassword property returns or sets the owner password used to access the Microsoft® SQL Server™ 2000 Data Transformation Services (DTS) package specified by the DTSPackageFileName property.

Security Note:
When possible, prompt users to enter their credentials at run time. Avoid hard-coding or storing credentials in a file. If credentials must be persisted between runs, encrypt them using the Win32 CryptoAPI functions. For more information, see this Microsoft Web site.

Syntax

object.DTSPackagePassword [= string]

Part	Description
object	Expression that evaluates to a SQLDistribution Object (Replication ActiveX) object.
string	Password needed to access the specified DTS package.

Applies To

SQLDistribution Object (Replication ActiveX)

Remarks

This property is only supported for packages created in SQL Server 2000 and requires that the SQL Server 2000 DTS runtime be installed. For more information, see Transforming Published Data.

The DTS owner password must be provided for this property. The required access cannot be obtained with the user password.

This property returns the value to which the property was most recently set. It cannot be used to return the actual owner password of the DTS package specified by DTSPackageFileName Property (Replication ActiveX), unless it was set to that value previously.

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT DTSPackagePassword(BSTR pVal);
HRESULT DTSPackagePassword(BSTR* pVal);