TaskLogRecord Object
The TaskLogRecord object provides the contents of a task log record from an instance of Microsoft® SQL Server™. The log record contains information about the execution of a task in a Data Transformation Services (DTS) package that has been implemented to write task log records.
Properties
| ErrorCode Property | Properties Collection |
| ErrorDescription Property | SequenceID Property |
| Parent Property |
Remarks
Task log records are not automatically written by the task classes supplied with SQL Server 2000, but the PackageLog interface is available so that a custom task or the script of an ActiveScriptTask object can write them. They are written to the msdb database on the server specified by the package LogServerName property each time a task in a package that has been implemented to write them is executed, if the package LogToSQLServer property has been set.
Access the TaskLogRecord objects by using the EnumTaskLogRecords method of the PackageSQLServer object and iterating through the TaskLogRecords collection the method returns.