How to: View Events for the Integration Services Service

There are two tools in which you can view events for the Integration Services service:

  • The Log File Viewer dialog box in SQL Server Management Studio. The Log File Viewer dialog box includes options to export, filter, and search the log. For more information about the options in the Log File Viewer, see Log File Viewer (Object Explorer).

  • The Windows Event Viewer.

To view service events for Integration Services in SQL Server Management Studio

  1. Open SQL Server Management Studio.

  2. On the File menu, click Connect Object Explorer.

  3. In the Connect to Server dialog box, select the Integration Services server type, select or locate the server to connect to, and then click Connect.

  4. In Object Explorer, right-click Integration Services and click View Logs.

  5. To view Integration Services events, select SQL Server Integration Services. The NT Events option is automatically selected and cleared with the SQL Server Integration Services option.

To view service events for Integration Services in Windows Event Viewer

  1. In Control Panel, if you are using Classic View, click Administrative Tools, or, if you are using Category View, click Performance and Maintenance and then click Administrative Tools.

  2. Click Event Viewer.

  3. In the Event Viewer dialog box, click Application.

  4. In the Application snap-in, locate an entry in the Source column that has the value SQLISService, right-click the entry, and then click Properties.

  5. Optionally, click the up or down arrow to show the previous or next event.

  6. Optionally, click the Copy to Clipboard icon to copy the event information.

  7. Choose to display event data using bytes or words.

  8. Click OK.

  9. On the File menu, click Exit to close the Event Viewer dialog box.