StepLogRecords Collection
The StepLogRecords collection contains StepLogRecord objects that provide the contents of step log records from an instance of Microsoft® SQL Server™. The log records contain information about the execution of a step in a DTS package.
Properties
| EOF Property |
Methods
Next MethodRemarks
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.
Use the EnumStepLogRecords method of the PackageSQLServer object to return the StepLogRecords collection.
Iterate through the objects of the StepLogRecords 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®.