PackageRepository Object

DTS Programming

DTS Programming

PackageRepository Object

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.

Properties
Name Property Properties Collection
Parent Property  
Methods
EnumPackageInfos Method EnumStepLineages Method
EnumPackageLineages Method  

Remarks

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.

See Also

Application Object

GetPackageRepository Method

Retrieving DTS System, Package and Log Data