PackageLogRecord Object

DTS Programming

DTS Programming

PackageLogRecord Object

The PackageLogRecord object provides the contents of a package log record from an instance of Microsoft® SQL Server™. The log record contains information about a package execution.

Properties
Computer Property LogDate Property
Description Property Name Property
ErrorCode Property Operator Property
ErrorDescription Property PackageID Property
ExecutionTime Property Parent Property
FinishTime Property Properties Collection
LineageFullID Property StartTime Property
LineageShortID Property  
Remarks

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

Access the PackageLogRecord objects by using the EnumPackageLogRecords method of the PackageSQLServer object and iterating through the PackageLogRecords collection the method returns.

See Also

EnumPackageLogRecords Method

LogServerName Property

LogToSQLServer Property

PackageLogRecords Collection

PackageSQLServer Object

Retrieving DTS System, Package and Log Data