PackageLineages Collection

DTS Programming

DTS Programming

PackageLineages Collection

The PackageLineages collection contains PackageLineage objects that provide the contents of package lineage records from Microsoft® SQL Server™ 2000 Meta Data Services. The records contain information about a DTS package execution hosted by Meta Data Services.

Properties
EOF Property
Methods
Next 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.

Use the EnumPackageLineages method of the PackageRepository object to return the PackageLineages collection.

Iterate through the objects of the PackageLineages collection by checking the EOF property after calling the Next method. If EOF is TRUE, Next will have returned Nothing and all the elements will have been fetched. You can also use For Each ... Next in Microsoft Visual Basic®.

See Also

EnumPackageLineages Method

LineageOptions Property

PackageLineage Object

PackageRepository Object

Retrieving DTS System, Package and Log Data