I’ve just put out a new version of sp_ssiscatalog. The main change is requesting a list of executions using:
exec sp_ssiscatalog @operation_type='execs'
returns a new field called relative_duration:
This length of the “bar” in that field represents the duration of that execution relative to all the other executions in the resultset. Put more simply, its an attempt to simply visualise which executions took the longest to complete.
The other change in this release is the addition of a new parameter called @ot which is simply a short form of @operation_type. Its there because I basically got fed up of typing @operation_type every time I wanted a list of executions. hence the statement above can now be written as:
exec sp_ssiscatalog @ot='execs'
That’s it, you can download the latest bits from http://ssisreportingpack.codeplex.com/releases/view/103452. Installation instructions are in my previous blog post on sp_ssiscatalog sp_ssiscatalog v22.214.171.124 now available for download [SSIS].
Look for more updates coming soon, I’m hoping to pick up the pace of iterations on this.