View Log Entries in the Log Events Window
Applies To: SQL Server 2016
This procedure describes how to run a package and view the log entries it writes. You can view the log entries in real time. The log entries that are written to the Log Events window can also be copied and saved for further analysis.
It is not necessary to write the log entries to a log to write the entries to the Log Events window.
In SQL Server Data Tools, open the Integration Services project that contains the package you want.
On the SSIS menu, click Log Events. You can optionally display the Log Events window by mapping the View.LogEvents command to a key combination of your choosing on the Keyboard page of the Options dialog box.
On the Debug menu, click Start Debugging.
As the runtime encounters the events and custom messages that are enabled for logging, log entries for each event or message are written to the Log Events window.
On the Debug menu, click Stop Debugging.
The log entries remain available in the Log Events window until you rerun the package, run a different package, or close SQL Server Data Tools.
View the log entries in the Log Events window.
Optionally, click the log entries to copy, right-click, and then click Copy.
Optionally, double-click a log entry, and in the Log Entry dialog box, view the details for a single log entry.
In the Log Entry dialog box, click the up and down arrows to display the previous or next log entry, and click the copy icon to copy the log entry.
Open a text editor, paste, and then save the log entry to a text file.