PackageLogRecords Collection

DTS Programming

DTS Programming

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
Next Method
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

EnumPackageLogRecords Method

LogServerName Property

LogToSQLServer Property

PackageLogRecord Object

PackageSQLServer Object

Retrieving DTS System, Package and Log Data