SaveToRepository Method

DTS Programming

DTS Programming

SaveToRepository Method

The SaveToRepository method saves information being held in the Package2 object and its subordinate objects and collections to the specified instance of Microsoft® SQL Server™ 2000 Meta Data Services.

Applies To
Package Object Package2 Object
Syntax

object.SaveToRepository(
    RepositoryServerName,
    RepositoryDatabaseName,
    RepositoryUserName,
    RepositoryUserPassword,
    [Flags],
    [CategoryID],
    [pVarPersistStgOfHost])

Part Description
object Expression that evaluates to an object in the Applies To list.
RepositoryServerName A string specifying the name of the server on which the instance of Meta Data Services is hosted.
RepositoryDatabaseName A string specifying the name of the database in which the instance of Meta Data Services is located.
RepositoryUsername A string specifying the logon name used to access the server specified by ServerName.
RepositoryUserPassword A string specifying the password used to access the server specified by ServerName.
Flags A value from the DTSRepositoryStorageFlags constants that specifies the type of user authentication used to access the server specified by RepositoryServerName.
CategoryID Reserved.
pVarPersistStgOfHost Screen layout information associated with a package (for internal use).

Remarks

RepositoryDatabaseName is evaluated as an ODBC datasource name (DSN) if RepositoryServerName is empty or NULL. Otherwise, RepositoryServerName and RepositoryDatabaseName are used to create a DSN-less connection.

A new VersionID value is always generated when the package is saved.

Prototype (C/C++)

HRESULT SaveToRepository(
    BSTR RepositoryServerName,
    BSTR RepositoryDatabaseName,
    BSTR RepositoryUserName,
    BSTR RepositoryUserPassword,
    DTSRepositoryStorageFlags Flags,
    BSTR CategoryID,
    VARIANT pVarPersistStgOfHost);

See Also

DTSRepositoryStorageFlags

Managing DTS Package Programs

SaveAs Method

SaveToRepositoryAs Method

SaveToSQLServer Method

SaveToStorageFile Method