DTS Programming

ServerName Property

The ServerName property sets or returns the name of the server on which the Data Transformation Services (DTS) package to be run by an ExecutePackageTask object is located.

Applies To

ExecutePackageTask Object

Syntax

object.ServerName [= name]

Part	Description
object	Expression that evaluates to an ExecutePackageTask object
name	Name of the server on which the DTS package to be run is located

Data Type

String

Modifiable

Read/write

Prototype (C/C++)

HRESULT ServerName(BSTR* pRetVal);

HRESULT ServerName(BSTR pRetVal);

Remarks

If ServerName property is not provided, the local computer is used; you can also specify "(local)".

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

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