The PackageRepository object provides access to the Data Transformation Services (DTS) components hosted by an instance of Microsoft® SQL Server™ 2000 Meta Data Services. Through methods of this object, you can obtain information about the DTS packages stored in Meta Data Services and access the contents of the package and step lineage data for these packages.
A package lineage record is written each time a package stored in Meta Data Services is executed, if the package LineageOptions property specifies this to be done.
Access the PackageRepository object by using the GetPackageRepository method of the Application object. Provide the necessary login information to access the instance of SQL Server that hosts the desired Meta Data Services instance.