Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Troubleshooting Reports for Package Execution

SQL Server 2012

In the current release of SQL Server Integration Services, standard reports are available in SQL Server Management Studio to help you monitor and troubleshoot Integration Services packages that have been deployed to the Integration Services catalog. Two of these package reports in particular help you to view package execution status and identify the cause of execution failures.

  • Integration Services Dashboard - This report provides an overview of all the package executions on the SQL Server instance in the past 24 hours. The report displays information such as Status, Operation Type, Package Name, etc., for each package.

    The Start Time, End Time, and Duration can be interpreted as follows:

    • If the package is still running, then Duration = current time – Start Time

    • If the package has completed, then Duration = End Time – Start Time

    For each package that has run on the server, the dashboard allows you to "zoom in" to find specific details on package execution errors that may have occurred. For example, click Overview to display a high-level overview of the status of the tasks in the execution, or All Messages to display the detailed messages that were captured as part of the package execution.

    You can filter the table displayed on any page by clicking Filter and then selecting criteria in the Filter Settings dialog. The filter criteria available depends on the data being displayed. You can change the sort order of the report by clicking the sort icon in the Filter Settings dialog.

  • Activity - All Executions Report – This report displays a summary of all Integration Services executions that have been performed on the server. The summary displays information for each execution such as status, start time, and end time. Each summary entry includes links to more information about the execution including messages generated during execution and performance data. As with the Integration Services Dashboard, you can apply a filter to the table to narrow down the information displayed.

Operations Reports for the Integration Services Server

Troubleshooting Tools for Package Execution

Integration Services icon (small)  Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN:


For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.