RemoveAllLogRecords Method

DTS Programming

DTS Programming

RemoveAllLogRecords Method

The RemoveAllLogRecords method removes all package, step, and task log records from the database associated with the PackageSQLServer object.

Applies To
PackageSQLServer Object
Syntax

object.RemoveAllLogRecords( )

Part Description
object Expression that evaluates to a PackageSQLServer object

Remarks

Log records are written to the msdb database on the instance of Microsoft® SQL 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. The RemoveAllLogRecords method removes these records for all packages from the database.

Prototype (C/C++)

HRESULT RemovePackageLogRecords( );

See Also

LogServerName Property

LogToSQLServer Property

PackageLogRecords Collection

RemovePackageLogRecords Method

RemoveStepLogRecords Method

RemoveTaskLogRecords Method

Retrieving DTS System, Package, and Log Data

StepLogRecords Collection

TaskLogRecords Collection