DTS Programming

LogToSQLServer Property

The LogToSQLServer property sets or returns a value indicating whether Data Transformation Services (DTS) package execution is logged to the specified Microsoft® SQL Server™ 2000 msdb database.

Applies To

Package2 Object

Syntax

object.LogToSQLServer [= boolean]

Part	Description
object	Expression that evaluates to a Package2 object
boolean	Boolean that specifies whether package execution is logged to the specified msdb database

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetLogToSQLServer(VARIANT_BOOL* pRetVal);

HRESULT SetLogToSQLServer(VARIANT_BOOL pRetVal);

Remarks

The default is FALSE, package execution is logged to a log file or the Microsoft Windows® event log. If TRUE, the LogServerName property specifies the instance of SQL Server to which logs are written.