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.