DTS Programming

ServerPassword Property

The ServerPassword property sets or returns the login password for the instance of Microsoft® SQL Server™ that contains the Data Transformation Services (DTS) package to be run by an ExecutePackageTask object.

Applies To

ExecutePackageTask Object

Syntax

object.ServerPassword [= password]

Part	Description
object	Expression that evaluates to an ExecutePackageTask object
password	Login password for the instance of SQL Server that contains the DTS package to be run

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT ServerPassword(BSTR* pRetVal);

HRESULT ServerPassword(BSTR pRetVal);

Remarks

The ServerPassword and ServerUserName properties must be provided unless UseTrustedConnection is TRUE or the DTS package is contained in a storage file.

Note It is recommended that you connect to an instance of SQL Server using Windows Authentication instead of SQL Server Authentication. To use Windows Authentication, set UseTrustedConnection to TRUE.

This property also can be referenced through the Properties collection of the Task object with the following code:

Set taskprops = task.Properties
taskprops("ServerPassword") [= password]