Minnu

• Apr 16th, 2007

 

 Its
        1) Terse
        2) Normal
        3) Verbose Init
        4) Verbose data

Sumithav29

 Profile Answers by Sumithav29 

• Jun 12th, 2009

 

When you configure a transformation, you can set the amount of detail the Integration Service writes in the session log.

The session log tracing levels are:

1. Normal: Integration Service logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes session results, but not at the level of individual rows.

2. Terse: Integration Service logs initialization information and error messages and notification of rejected data.

3. Verbose Initialization: In addition to normal tracing, Integration Service logs additional initialization details, names of index and data files used, and detailed transformation statistics.

4. Verbose Data: In addition to verbose initialization tracing, Integration Service logs each row that passes into the mapping. Also notes where the Integration Service truncates string data to fit the precision of a column and provides detailed transformation statistics.

By default, the tracing level for every transformation is Normal.