THE SQL Server Blog Spot on the Web

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

Jamie Thomson

This is the blog of Jamie Thomson, a freelance data mangler in London

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:

image

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 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.

@Jamiet

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

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement