GetPackageSQLServer Method

DTS Programming

DTS Programming

GetPackageSQLServer Method

The GetPackageSQLServer method returns a PackageSQLServer object for the server specified by the input parameters.

Applies To
Application Object
Syntax

Set object = appobject.GetPackageSQLServer(
    ServerName,
    UserName ,
    Password ,
    ConnectionFlags
)

Part Description
object Expression that evaluates to a PackageSQLServer object.
appobject Expression that evaluates to an Application object.
ServerName A string specifying the name of the server to which to connect.
UserName A string specifying the logon name used to access the server specified by ServerName.
Password A string specifying the password used to access the server specified by ServerName.
ConnectionFlags A value from the DTSSQLServerStorageFlags constants that specifies the type of user authentication used to access the server specified by ServerName.

Remarks

The PackageSQLServer object provides access to the Data Transformation Services (DTS) packages and log data stored on the associated server, which must be running an instance of Microsoft® SQL Server™.

UserName and Password need be specified (nonempty string) only if ConnectionFlags has the value DTSSQLStgFlag_Default, which implies database authentication.

Prototype (C/C++)

HRESULT GetPackageSQLServer(
    BSTR ServerName,
    BSTR Username,
    BSTR Password,
    DTSSQLServerStorageFlags ConnectionFlags,
    IDTSPackageSQLServer **pRetVal );

See Also

DTSSQLServerStorageFlags

GetPackageRepository Method

PackageSQLServer Object

Retrieving DTS System, Package, and Log Data