THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » usp_ssiscatalog   (RSS)
  • Did you know documentation is built-in to usp_ssiscatalog?

    I am still working apace on updates to my open source project SSISReportingPack, specifically I am working on improvements to usp_ssiscatalog which is a stored procedure that eases the querying and exploration of the data in the SSIS Catalog. In this blog post I want to share a titbit of information about usp_ssiscatalog, that all the actions ...
    Posted to Jamie Thomson (Weblog) by jamiet on May 14, 2014
  • SSIS ReportingPack v1.1.1.0 – Execution Stats visualised in a Gannt chart via usp_ssiscatalog

    There are many SSRS reports in SSIS Reporting Pack and the one I’ve perhaps spent most time on is the executable_duration report which provides this visualisation: I happen to think this is really useful because it shows the start time and duration of each executable relative to all the other executables in an execution. It does it by ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 5, 2013
  • SSISReportingPack with usp_ssiscatalog v1.1 available – first release with integrated installer

    Since December 2010 I have been maintaining a suite of reports that can be used atop the SSIS Catalog in SSIS 2012, I called it the “SSIS Reporting Pack”. While building those reports I realised that there was also a need to make it easier to issue common but ad-hoc queries against the SSIS Catalog and that realisation gave rise to a stored ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 4, 2013
  • sp_ssiscatalog v1.0.4.0 available now with new feature - view most recent failed execution [SSIS]

    Development of sp_ssiscatalog continues apace with a new release today (4th July 2013). In this release I have enabled a new action called ‘exec_failed’ which can be simply described as “Show me the most recent failed execution”. The syntax is very simple: exec sp_ssiscatalog @action = 'exec_failed' exec sp_ssiscatalog @a = ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 4, 2013
  • 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 ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 15, 2013
  • sp_ssiscatalog v1.0.2.0 now available for download [SSIS]

    v1.0.2.0 – what’s in it? Things have been a bit quiet on the sp_ssiscatalog front since I last blogged about it three months ago in December 2012. Rest-assured development continues apace however and today I’m making available a minor update, v1.0.2.0 which is now available for download from Codeplex. For those that don’t know I describe ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 11, 2013
  • Documenting sp_ssiscatalog

    What is the best way to document an API? Moreover, what is the best way to document a T-SQL API? Before I try to answer those questions I should explain what I mean by “a T-SQL API”. I think of an API as being a collection of well-defined, known, code modules that provide some notion of a service to whomever uses it; in T-SQL terms I tend to ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 4, 2012
  • sp_ssiscatalog v1.0.1.0 now available for download

    13 days ago I wrote a blog post entitled Introducing sp_ssiscatalog (v1.0.0.0) in which I first made mention of sp_ssiscatalog, an open source stored procedure intended to make it easy to query the SSIS Catalog. I have been working on some enhancements since then and hence v1.0.1.0 is now available for download from Codeplex. What’s new in this ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 20, 2012
  • Introducing sp_ssiscatalog (v1.0.0.0)

    Regular readers of my blog may know that over the last year I have made available a suite of SQL Server Reporting Services (SSRS) reports that provide visualisations of the data in the SQL Server Integration Services (SSIS) 2012 Catalog. Those reports are available at http://ssisreportingpack.codeplex.com. As I have built these reports and used ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 6, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement