DTSPackagePassword Property

SQL-DMO

SQL-DMO

DTSPackagePassword Property

The DTSPackagePassword property specifies a Data Transformation Services (DTS) package password.

Applies To
TransPullSubscription2 Object TransSubscription2 Object
Syntax

object.DTSPackagePassword

Parts

Object

Expression that evaluates to an object in the Applies To list

Value

String that specifies the password for a DTS package used during a replication operation.

Data Type

String

Modifiable

Write-only

Prototype (C/C++)

HRESULT SetDTSPackagePassword(SQLDMO_LPCSTR NewValue);

Remarks

Set the DTSPackagePassword property after setting the DTSPackageName property. It is only necessary to set DTSPackagePassword if the DTS package is password protected.

Note  If an application calls DTSPackagePassword on an instance of Microsoft® SQL Server™ version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000" are returned.

See Also

AllowDTS Property

DTSPackageLocation Property

DTSPackageName Property