DB v1.0.1.0

Rating: No reviews yet
Downloads: 406
Change Set: 70359
Released: Nov 20, 2012
Updated: Nov 21, 2012 by jamiet
Dev status: Stable Help Icon

Recommended Download

Application SSISReportingPackDB_v1.0.1.0.zip
application, 238K, uploaded Nov 20, 2012 - 406 downloads

Release Notes

Overview

Latest release of the database for SSIS Reporting Pack.

The database consists of sp_ssiscatalog, a stored procedure that makes it easy to query the SSIS Catalog along with some other code modules that get called from sp_ssiscatalog, although they can be executed independently if you so wish.

Changes in this release

  • [execution_id] now gets returned in a call to
EXEC [dbo].[sp_ssiscatalog] @operation_type='exec';
  • Filter events by specifying packages to ignore
EXEC [dbo].[sp_ssiscatalog] @operation_type='exec',@exec_events_packagesexcluded='SomePackage.dtsx';
  • [event_message_id] is now returned in a list of events
  • List of executions can now be filtered via a minimum and maximum execution_id
EXEC [dbo].[sp_ssiscatalog] @operation_type='execs',@execs_minimum_execution_id=198,@execs_maximum_execution_id=201
  • Events resultsets now have a field, [event_message_context_xml] that contains an XML document containing all [event_message_context] info (if any exists)

Installation instructions

  1. Download the zip file herein. it contains two files, SsisReportingPack.dacpac & SSISDB.dacpac
  2. Unzip to a folder of your choosing
  3. Open a command prompt and change to the directory into which you unzipped the files
  4. Execute:
"%PROGRAMFILES(x86)%\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe" /a:Publish /tdn:SsisReportingPack /sf:SSISReportingPack.dacpac /v:SSISDB=SSISDB /tsn:(local)
(/tsn specifies the target server. Change as appropriate.)
This will create a database called [SsisReportingPack] which contains [dbo].[sp_ssiscatalog]

Reviews for this release

No reviews yet for this release.