THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a data mangler in London working for Dunnhumby

sp_ssiscatalog v1.0.3.0 available now [SSIS]

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 Installation instructions are in my previous blog post on sp_ssiscatalog sp_ssiscatalog v1.0.2.0 now available for download [SSIS].

Look for more updates coming soon, I’m hoping to pick up the pace of iterations on this.


Published Saturday, March 16, 2013 12:19 AM by jamiet
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


This Blog


Privacy Statement