Tracing is a valuable method of troubleshooting. Tracing allows you to log the Insight activity including operations against the SCRIBEINTERNAL database and operations against your connections. By default, trace files open in Notepad.
In the trace, you can see the step flow that was followed during the DTS file run.
Browse through the trace file with a text editor to find the error you are trying to resolve. The error number and error message are shown.
Note: To make the trace file easier to read, turn on the word wrap option if available, in your text editor.
To Enable Tracing
You can also click Browse and navigate to the location of the trace file.
Tip: Before analyzing the trace file, try using the Transaction Error Report, which is easier to manage and read.