GetPackageRepository Method

DTS Programming

DTS Programming

GetPackageRepository Method

The GetPackageRepository method returns a PackageRepository object for the server and database specified by the input parameters.

Applies To
Application Object
Syntax

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

Remarks

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.

Prototype (C/C++)

HRESULT GetPackageRepository(
    BSTR ServerName,
    BSTR DatabaseName,
    BSTR Username,
    BSTR Password,
    DTSRepositoryStorageFlags ConnectionFlags,
    IDTSPackageRepository **pRetVal );

See Also

DTSRepositoryStorageFlags

GetPackageSQLServer Method

PackageRepository Object

Retrieving DTS System, Package, and Log Data