StepLogRecord Object

DTS Programming

DTS Programming

StepLogRecord Object

The StepLogRecord object provides the contents of a step log record from an instance of Microsoft® SQL Server™. The log record contains information about the execution of a step in a Data Transformation Services (DTS) package.

Properties
ErrorCode Property Parent Property
ErrorDescription Property ProgressCount Property
ExecutionTime Property Properties Collection
FinishTime Property StartTime Property
LineageFullID Property StepExecutionID Property
Name Property StepExecutionResult Property
Remarks

A step log record is written to the msdb database on the server specified by the package LogServerName property each time a step in a package is executed, if the package LogToSQLServer property has been set.

Access the StepLogRecord objects by using the EnumStepLogRecords method of the PackageSQLServer object and iterating through the StepLogRecords collection the method returns.

See Also

EnumStepLogRecords Method

LogServerName Property

LogToSQLServer Property

PackageSQLServer Object

Retrieving DTS System, Package and Log Data

StepLogRecords Collection