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.