| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Troubleshooting Reports for Package Execution |
Troubleshooting Reports for Package Execution |
chugugrace |
chugu |
03/14/2017 |
sql |
integration-services |
conceptual |
[!INCLUDEsqlserver-ssis]
In the current release of [!INCLUDEssNoVersion] [!INCLUDEssISnoversion], standard reports are available in [!INCLUDEssManStudioFull] to help you monitor and troubleshoot [!INCLUDEssISnoversion] packages that have been deployed to the [!INCLUDEssISnoversion] 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssISnoversion] 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.