Simple SSIS package monitoring for SQL Server 2008, Part Two

In part one we developed a query that nets us some cool performance metrics and compacts the big-ugly syssislog into a more readable format.   In part two, we’re going to use SSRS to visualize that data.  If you’re using SQL Server 2012, checkout the Execution And Logging Reports.  For the rest of us pedestrians on SQL Server 2008 or 2005, there is a download button at the bottom of this article filled with SSRS reports that will create an SSIS monitoring dashboard.  These will query the sysssislog and present that data in a similar fashion.   When you execute the report, here is what you should see… Continue reading Simple SSIS package monitoring for SQL Server 2008, Part Two

Simple SSIS package monitoring for SQL Server 2008, Part One

Business Intelligence analyst have been using SSIS for almost a decade now and yet we still have no centralized place to answer some very common operating questions.  Such as…

  • How many packages do we have?
  • How often are they run?
  • How are they configured?
  • How are these packages performing over time?

Microsoft recently addressed this in their latest version of SQL Server 2012 by introducing the SSIS Catalog and the new Execution and Logging reports.  They enable a fast way to visualize and troubleshoot performance.

SSISExecutionAndLoggingReports

But what about those of us still using SQL Server 2008 or 2005?  Are we left without a way to visualize our package environment? Continue reading Simple SSIS package monitoring for SQL Server 2008, Part One