The LoadFromSQLServer method loads the DTS package from the specified server running Microsoft® SQL Server™. This includes information held in the objects and collections that belong to the Package object.
| Package Object |
object.LoadFromSQLServer(
ServerName,
[ServerUserName],
[ServerPassword],
[Flags],
[PackagePassword],
[PackageGuid],
[PackageVersionGuid],
[PackageName],
[pVarPersistStgOfHost])
| Part | Description |
|---|---|
| Package | Expression that evaluates to an object in the Applies To list |
| ServerName | Server name |
| ServerUserName | Server username |
| ServerPassword | Server user password |
| bTrustedConnection | Whether to use a trusted connection |
| PackagePassword | Package password if the package is encrypted |
| PackageGuid | Package identifier, which is a string representation of a GUID |
| PackageVersionGuid | Version identifier which is a string representation of a GUID |
| PackageName | Package name |
If PackageVersionGUID is not specified or is blank, the most recent version of the package is retrieved.
HRESULT LoadFromSQLServer(BSTR ServerName,
BSTR ServerUserName,
BSTR ServerPassword,
VARIANT_BOOL bTrustedConnection,
BSTR PackagePassword,
BSTR PackageGuid,
BSTR PackageVersionGuid,
BSTR PackageName,
LPUNKNOWN pUnkPersistStgOfHost);