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]