SaveToSQLServerAs Method
The SaveToSQLServer method saves information being held in the Package2 object and its subordinate objects and collections to the specified server running an instance of Microsoft® SQL Server™. The new name and a new package ID are assigned.
Applies To
Package2 Object |
Syntax
object.SaveToSQLServerAs(
NewName,
ServerName,
[ServerUserName],
[ServerPassword],
[Flags],
[PackageOwnerPassword],
[PackageOperatorPassword],
[PackageCategoryID],
[pVarPersistStgOfHost],
[bReusePasswords])
Part | Description |
---|---|
object | Expression that evaluates to a Package2 object. |
NewName | A string specifying the new name for the package. |
ServerName | A string specifying the name of the server to which to connect. |
ServerUserName | A string specifying the logon name used to access the server specified by ServerName. |
ServerPassword | A string specifying the password used to access the server specified by ServerName. |
Flags | A value from the DTSSQLServerStorageFlags constants that specifies the type of user authentication used to access the server specified by ServerName. |
PackageOwnerPassword | A string specifying the package owner password if the package is encrypted. |
PackageOperatorPassword | A string specifying the package user password if the package is encrypted. |
PackageCategoryID | A string specifying the package category (reserved. |
pVarPersistStgOfHost | Screen layout information associated with a package (for internal use). |
bReusePasswords | A Boolean specifying whether to reuse package passwords. |
Remarks
New package ID and version ID values are generated when the package is saved, and the new name is assigned.
The default for bReusePasswords is True.
Prototype (C/C++)
HRESULT SaveToSQLServerAs(
BSTR NewName,
BSTR ServerName,
BSTR ServerUserName,
BSTR ServerPassword,
DTSSQLServerStorageFlags Flags,
BSTR PackageOwnerPassword,
BSTR PackageOperatorPassword,
BSTR PackageCategoryID,
VARIANT pVarPersistStgOfHost),
VARIANT_BOOL bReusePasswords);