DTS Programming

Password Property

The Password property specifies the password to use when making the connection.

Applies To

Connection Object	SendMailTask Object
Connection2 Object

Syntax

object.Password [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	Password to use

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetPassword(BSTR *pRetVal);

HRESULT SetPassword(BSTR NewValue);

Remarks

Use the Password property in conjunction with the UserID property to make the connection. You must provide values for Password and UserID unless UseTrustedConnection is TRUE.

Note The recommended way to connect to an instance of Microsoft® SQL Server™ is to use Windows Authentication instead of SQL Server Authentication. Set UseTrustedConnection to TRUE to use Windows Authentication.