The SaveToSQLServer method saves information being held in the Package object to 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.SaveToSQLServer(
ServerName,
[ServerUserName],
[ServerPassword],
[Flags],
[PackageOwnerPassword],
[PackageOperatorPassword],
[PackageCategoryID],
[pVarPersistStgOfHost],
[ReusePasswords])
| 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 |
| PackageCategoryID | Package category |
| VarPersistStorageofHost | Screen layout information associated with a package (for internal use) |
| ReusePasswords | Whether to reuse a password |
A new PackageVersionGUID value is always generated when the package is saved.
HRESULT SaveToSQLServer(BSTR ServerName,
BSTR ServerUserName,
BSTR ServerPassword,
VARIANT_BOOL bTrustedConnection,
BSTR PackagePassword,
BSTR PackageCategoryID,
LPUNKNOWN pUnkPersistStgOfHost),
VARIANT_BOOL beReusePasswords);