Log

Log is used to store the information on ETL tasks execution. In fact, a log is a table with predefined list of fields. The number of fields is fixed, but there is also a possibility to add new fields.

Information on the following operations is saved to log:

• Recording the start of ETL task execution.

• ETL task execution error.

• Skip records.

• Add records.

• Recording the completion of ETL task execution.

In the Object Navigator dialog box select the following items to create a log:

• The Create > Other > Log context menu item.

• The New Object > Other > Log item in the Create group on the Home ribbon tab.

The log can be also created from the ETL task. In the opened ETL task select the Task > Properties main menu item, in the wizard that opens go to theTask Options page and click the Create button.

A log creation wizard opens after executing one of the operations:

NOTE. It is available to create and process log only in the desktop application.

Log creation wizard pages

Log fields

Working with a Log

To view log data, select required object in the object navigator and execute one of the following operations:

• Double-click with the main mouse button.

• Select the Open context menu item.

• Select the View item on the Home ribbon tab.

A dialog box with data opens. Description of this dialog box and principles of working are described in the Working with Data Set section.

Linking the Log to the ETL Task

To link a log to an ETL task, execute the following operations:

1. Use the log creation wizard to create a new log.

2. Open the ETL tasks object to which the log is linked.

3. Select the Task > Properties item in the main menu of the ETL task after which the ETL task editing wizard will be displayed.

4. Select the created log on theTask Options on the wizard page.

See also:

Relational Objects of Repository | ILog