The GetPackageRepository method returns a PackageRepository object for the server and database specified by the input parameters.
Set object = appobject.GetPackageRepository(
ServerName,
DatabaseName,
UserName ,
Password ,
ConnectionFlags )
| Part | Description |
|---|---|
| object | Expression that evaluates to a PackageRepository object |
| appobject | Expression that evaluates to an Application object |
| ServerName | A string specifying the name of the server on which the Microsoft® SQL Server™ 2000 Meta Data Services instance is hosted |
| DatabaseName | A string specifying the name of the database in which the instance of Meta Data Services is located |
| UserName | A string specifying the logon name used to access the server specified by ServerName |
| Password | A string specifying the password used to access the server specified by ServerName |
| ConnectionFlags | A value from the DTSRepositoryStorageFlags constants that specifies the type of user authentication used to access the server specified by ServerName |
The PackageRepository object provides access to the Data Transformation Services (DTS) packages and lineage data stored on the associated instance of Meta Data Services.
UserName and Password need be specified (nonempty string) only if ConnectionFlags has the value DTSReposFlag_Default, which implies database authentication.
HRESULT GetPackageRepository(
BSTR ServerName,
BSTR DatabaseName,
BSTR Username,
BSTR Password,
DTSRepositoryStorageFlags ConnectionFlags,
IDTSPackageRepository **pRetVal );