StepLineages Collection

DTS Programming

DTS Programming

StepLineages Collection

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

Properties
EOF Property
Methods
Next Method
Remarks

A step lineage record is written each time a step of a package stored in Meta Data Services is executed, if the package LineageOptions property specifies this to be done.

Use the EnumStepLineages method of the PackageRepository object to return the StepLineages collection.

Iterate through the objects of the StepLineages 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

EnumStepLineages Method

LineageOptions Property

PackageRepository Object

Retrieving DTS System, Package and Log Data

StepLineage Object