First release of the database for SSIS Reporting Pack.
At this stage the database consists of sp_ssiscatalog, a stored procedure that makes it easy to query the SSIS Catalog.
- Download the zip file herein. it contains two files, SsisReportingPack.dacpac & SSISDB.dacpac
- Unzip to a folder of your choosing
- Open a command prompt and change to the directory into which you unzipped the files
"%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]