How to: View Integration Services Service Events in SQL Server Management Studio

This procedure describes how to view the event log for Integration Services service in 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.

To view service events 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.

See Also

Tasks

Managing the Integration Services Service
How to: Add a Log for Data Flow Performance Counters

Other Resources

Administering Integration Services

Help and Information

Getting SQL Server 2005 Assistance