LoadFromSQLServer Method (DTS)

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.

Applies To
Package Object  

Syntax

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

Remarks

If PackageVersionGUID is not specified or is blank, the most recent version of the package is retrieved.

Prototype (C/C++)

HRESULT LoadFromSQLServer(BSTR ServerName,
BSTR ServerUserName,
BSTR ServerPassword,
VARIANT_BOOL bTrustedConnection,
BSTR PackagePassword,
BSTR PackageGuid,
BSTR PackageVersionGuid,
BSTR PackageName,
LPUNKNOWN pUnkPersistStgOfHost);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.