Sr. SQL Server DBA
Verisk Health, Nepal
Sr. Software Developer
Severstal NA, Greater Detroit Area
Data Warehouse Architect
The SSIS Monitoring Console will display data that is recorded by the auditing framework. There are numerous reports that will display a variety of data, from real time monitoring to execution trend data.
There are two sets of reports; the real time monitoring reports and a list of static reports. Click ‘Launch Monitoring Console’ to monitor package execution.
This report will display the package as if it is being viewed in BIDS. Click the data flow button to view the data flows in the package.
Click the Dashboards tab in the upper left corner of the screen to view all the other reports. Select the Recent Executions Detail report.
Adjust the start and end date parameters (if necessary) and click preview.
This report will display packages that have recently executed. It will show package connections, variables, and a list of errors and warnings.
The Extract/Load Trend report will display information about the amount of rows that packages have been extracting and loading.
It breaks the packages down to sources and destinations and allows users to compare the amount of rows extracted and loaded.