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.