StepLineage Object

DTS Programming

DTS Programming

StepLineage Object

The StepLineage object provides the contents of a step lineage record from Microsoft® SQL Server™ 2000 Meta Data Services. The record contains information about the execution of a step in a Data Transformation Services (DTS) package hosted by Meta Data Services.

Properties
ErrorCode Property Name Property
ErrorDescription Property Parent Property
ErrorHelpContext Property Properties Collection
ErrorHelpFile Property StartTime Property
ErrorSource Property StepExecutionResult Property
ExecutionTime Property StepExecutionStatus Property
FinishTime Property  
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.

Access the StepLineage objects by using the EnumStepLineages method of the PackageRepository object and iterating through the StepLineages collection the method returns.

See Also

EnumStepLineages Method

LineageOptions Property

PackageRepository Object

Retrieving DTS System, Package and Log Data

StepLineages Collection