PackageLogRecords Collection

The PackageLogRecords collection contains PackageLogRecord objects that provide the contents of package log records from an instance of Microsoft® SQL Server™. The log records contain information about a DTS package execution.

Properties

EOF Property

Methods

Remarks

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

Use the EnumPackageLogRecords method of the PackageSQLServer object to return the PackageLogRecords collection.

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