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