SSIS Reporting Pack

21/03/2013

אין תגובות

Project Description on http://ssisreportingpack.codeplex.com/

 

* SSRS reports that operate over the SSIS catalog
* A stored proc, sp_ssiscatalog, that provides detailed analysis of the SSIS Catalog
Go to SSIS Reporting Pack for the documentation regarding the reports.
Go to sp_ssiscatalog for documentation on that.

Installation Overview

Pre-Requisites

  • These reports expose data from [SSISDB] hence you will need an instance of that database. See Catalog Overview in SQL Server “Denali” CTP1 – SSIS for instructions on how to create [SSISDB]
  • You will need a SQL Server Reporting Services Report Server onto which to deploy the reports. (Although, the installer provides a Visual Studio project for the reports so you could just view them from there. I think it makes more sense to deploy them to a server though.)
  • The installer does not (as yet) install the reports onto your Report Server, it only creates the requisite .rdl files on your machine. Hence, you will need the SQL Server 2012 development tools (aka SQL Server Data Tools aka SSDT), including the BI development tools, in order to deploy the reports to your Report Server.
  • Although not strictly a pre-requisite I highly recommend that you create an index on the [SSISDB].[internal].[event_messages].[operation_id] & [SSISDB].[internal].[operation_messages].[operation_id] fields. After using the reports in anger for a while now I have come to realize that any sizeable data volumes in [SSISDB] will severely impact your ability to get any results quickly, particularly if those results use view [SSISDB].[catalog].[event_messages]. Phil Brammer has done the hard work for you and prepared some scripts to create the indexes that he recommends and he has shared them via his blog at http://www.ssistalk.com/SSIS_2012_Missing_Indexes.zip
הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *