RemoveFromRepository Method
The RemoveFromRepository method removes the package from the specified instance of Microsoft® SQL Server™ 2000 Meta Data Services.
Applies To
Package Object | Package2 Object |
Syntax
Package.RemoveFromRepository RepositoryServerName, _
RepositoryDatabaseName, RepositoryUserName, RepositoryUserPassword, _
PackageID, [VersionID], [PackageName], [Flags]
Part | Description |
---|---|
Package | Expression that evaluates to an object in the Applies To list. |
RepositoryServerName | Meta Data Services server name. |
RepositoryDatabaseName | Meta Data Services database name or datasource name (DSN). |
RepositoryUsername | Meta Data Services user name. |
RepositoryUserPassword | Meta Data Services user password. |
PackageID | Package identifier, which is a string representation of a globally unique identifier (GUID). |
VersionID | Version identifier, which is a string representation of a GUID. |
PackageName | Package name. |
Flags | Value from the DTSRepositoryStorageFlags constants, which specified the user authentication type. |
Remarks
RepositoryDatabaseName is evaluated as an ODBC DSN if RepositoryServerName is empty or NULL. Otherwise, RepositoryServerName and RepositoryDatabaseName are used to create a connection without a DSN.
If VersionID is not specified or is blank, the most recent version of the package is removed.
Prototype (C/C++)
HRESULT RemoveFromRepository(
BSTR RepositoryServerName,
BSTR RepositoryDatabaseName,
BSTR RepositoryUserName,
BSTR RepositoryUserPassword,
BSTR PackageID,
BSTR VersionID CPPDEFAULT(= NULL)
BSTR PackageName CPPDEFAULT(= NULL)
DTSRepositoryStorageFlags Flags CPPDEFAULT(= DTSReposFlag_Default) );