Logs
The Data Integration Service generates log events when you run a mapping, run a profile, preview data, or run an SQL query. Log events include information about the tasks performed by the Data Integration Service, errors, and load summary and transformation statistics.
You can view the logs generated from the Developer tool and save them to a local directory.
You can view log events from the Show Log button in the Data Viewer view.
When you run a mapping from Run > Run Mapping, you can view the log events from the Progress view. To open the log events in the Developer tool, click the link for the mapping run and select Go to Log.
When you run a profile, you can view the log events from the Monitoring tool.
To save the log to a file, click File > Save a Copy As and choose a directory. By default the log files are stored in the following directory: c:\[TEMP]\AppData\Local\Temp.
Log File Format
The information in the log file depends on the sequence of events during the run. The amount of information that is sent to the logs depends on the tracing level.
The Data Integration Service updates log files with the following information when you run a mapping, run a profile, preview data, or run an SQL query:
- Logical DTM messages
Contain information about preparing to compile, to optimize, and to translate the mapping. The log events and the amount of information depends on the configuration properties set.
- Data Transformation Manager (DTM) messages
Contain information about establishing a connection to the source, reading the data, transforming the data, and loading the data to the target.
- Load summary and transformation statistics messages
- Contain information about the number of rows read from the source, number of rows output to the target, number of rows rejected, and the time to execute.