SSIS Reporting Pack v0.2 now available

jamiet — Sun, 04 Sep 2011 13:57:00 GMT

In December 2010 I announced in a blog post Introducing SSIS Reporting Pack for SQL Server code-named Denali that I planned to provide a series of reports that visualised information held in the SSIS Catalog in SQL Server Denali – I called these reports the SSIS Reporting Pack. At that time SSIS Reporting Pack was a precursor to what I really wanted to provide because the reports were built upon the SSIS Catalog from Denali CTP1; Denali CTP3 brought with it a whole heap of changes to the SSIS Catalog (read more at SSIS Logging in Denali) and accordingly SSIS Reporting Pack has been enhanced dramatically.

Download and Install

You can always download the latest release of SSIS Reporting Pack from http://ssisreportingpack.codeplex.com/releases/. In the release that I am announcing today (v0.2) the reports are delivered in an msi installer rather than simply a zip file as they were before, use the installer to easily make the reports available in whatever location you require:

After installation you will have a folder containing all the report project artefacts.

Open SSISReportingPack.rptproj in Visual Studio just as you would any other Reporting Services project from where you can deploy the reports to your Denali report server of choice. You will need to edit the data source (SSISCatalog.rds) to point to your SSIS Catalog (i.e. the [SSISDB] database). If you do not have your own instance of the SSIS Catalog database ([SSISDB]) but still wish to evaluate SSIS Reporting Pack I have made a copy of [SSISDB] available on SQL Azure that can be accessed using the following credentials:

Server		Username		Password	Database
enf3k2ao1m.database.windows.net		ro		r3@d0nly	SSISDB

The Reports

As I said above the reports have been changed in order to leverage the new additions to the SSIS Catalog in CTP3. The main enhancement I want to draw your attention to is the rich navigation of log data that is now provided

Notice that the log messages are now contextual, each message is shown against the executable that raised the message which in turn is indented indicating its position in the executable hierarchy. I expect this to be of great benefit when navigating package execution logs which, prior to Denali, was very difficult due to it essentially being a long flat list of messages.

SSIS Reporting Pack also has the ability to visualise the duration of each excutable:

In the simple example highlighted here by the red box we can see that iteration 3 of the For Each Loop “FEL Loop over top performing regions” took considerably longer than the two previous iterations; SSIS Reporting Pack gives us the tools we need to drill in and find out exactly where and why that slow down occurred.

Those are two of the main new features of SSIS Reporting Pack but there is lots more to discover so if you are evaluating SSIS in Denali I encourage you to download SSIS Reporting Pack and use it to learn about the plethora of data that is available in the SSIS Catalog. Please do bear in mind that this is still an early release so there are still lots of improvements to be made in the future; you can suggest improvements or report bugs either in the comments section below or (preferably) on the Discussions page at http://ssisreportingpack.codeplex.com/discussions.

@jamiet

Introducing SSIS Reporting Pack for SQL Server code-named Denali

jamiet — Wed, 08 Dec 2010 23:25:00 GMT

In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali:

The SSIS Catalog is responsible for executing SSIS packages and also for capturing the metadata from those executions. However, at the time of writing there is no mechanism provided to view analyse and drill into that metadata and that is the reason that I am, in this blog post, introducing a suite of SSIS Catalog reports called the SSIS Reporting Pack ~~which you can download from my SkyDrive at http://bit.ly/ez55g4.~~ The latest version of the reports can be gotten from http://ssisreportingpack.codeplex.com/releases/.

In this first release the SSIS Reporting Pack includes five reports:

Catalog – A high-level summary of all activity in the Catalog
Folders – A summary of activity in each Catalog Folder
Folder – Project-level activity per single Folder
Executions – A visualisation of all executions per Folder/Project/Package/Environment or subset thereof
Execution – Information about an individual execution

Here is a screenshot of the Executions report:

Notice that the SSIS Reporting Pack provides a visual overview of all executions in the Catalog. Each execution is represented as a bar on the bar chart, the success or otherwise of each execution is indicated by the colour of the bar and the execution time is indicated by the bar height.

I have recorded a video that gives an overview of the SSIS Reporting which I have embedded below. If you are having any trouble viewing the video go see it at http://vimeo.com/17617974

I must stress that this is a very early version of the SSIS Reporting Pack and I am expecting it to change a lot over the coming year. I am very keen to get some feedback about this, specifically:

let me know if anything does not work as you expect
give me your feature requests

The easiest way to get hold of of me for now is within the comments section of this blog post.

That’s all for now. I hope the SSIS Reporting Pack proves useful and I look forward to hearing your feedback. Lastly, that download link again: ~~http://bit.ly/ez55g4~~. http://ssisreportingpack.codeplex.com/releases/.

@jamiet

Search results matching tags 'SSIS', 'SSIS Reporting Pack', and 'SQL Server 2012'

SSIS Reporting Pack v0.2 now available

Download and Install

The Reports

Introducing SSIS Reporting Pack for SQL Server code-named Denali