The GetPackageSQLServer method returns a PackageSQLServer object for the server specified by the input parameters.
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. |
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.
HRESULT GetPackageSQLServer(
BSTR ServerName,
BSTR Username,
BSTR Password,
DTSSQLServerStorageFlags ConnectionFlags,
IDTSPackageSQLServer **pRetVal );