On the Task Settings page in the ETL task editing wizard specify the log that will store system messages about data import and export in the ETL task and other additional parameters.
Log is a repository object used to keep track of the operations executed during ETL task execution. The log is a table that initially contains a collection of fields to be logged. Additional fields can be added when a in the object navigator.
Set the following options:
Log. Specify the log in ETL task properties for operation logging. In the drop-down list of repository objects select a log, to which system messages about ETL task import or export are written. The Create button is used to create a new log.
Use Batch Data Processing. Batch data processing enables the user to process import or export records in parts (batches). The number of records processed in one batch is specified in the Batch Size box.
Display the Window with the Results of the Task Execution. In enables displaying of the window with results after ETL task execution.
Logged operations of an ETL task:
Execution start.
Execution error.
Skip records.
Add records.
End of execution.
See also: