This topic has not yet been rated - Rate this topic

Configure SSIS Logs (Details Tab)

SQL Server 2008 R2

Use the Details tab of the Configure SSIS Logs dialog box to specify the events to enable for logging and the information details to log. The information that you select applies to all the log providers in the package. For example, you cannot write some information to the SQL Server instance and different information to a text file.

Options

Events

Enable or disable events for logging.

Description

View a description of the event.

Advanced

Select or clear events to log, and select or clear information to log for each event. Click Basic to hide all logging details, except the list of events. The following information is available for logging:

Value	Description
Computer	The name of the computer on which the logged event occurred.
Operator	The user name of the person who started the package.
SourceName	The name of the package, container, or task in which the logged event occurred.
SourceID	The global unique identifier (GUID) of the package, container, or task in which the logged event occurred.
ExecutionID	The global unique identifier of the package execution instance.
MessageText	A message associated with the log entry.
DataBytes	Reserved for future use.

Basic

Select or clear events to log. This option hides logging details except the list of events. If you select an event, all logging details are selected for the event by default. Click Advanced to show all logging details.

Load

Specify an existing XML file to use as a template for setting logging options.

Save

Save configuration details as a template to an XML file.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Configure SSIS Logs (Details Tab)

Tasks

Reference

Concepts

Community Additions