I’ve released a (very early) version of SSIS Catalog Reports – v0.1 – on GitHub. You can access the project here.
My main goal is to provide some visibility into the SSIS Catalog without the need for SQL Server Management Studio. “Why, Andy?” I’m glad you asked. In some enterprises, there may be:
-
Operations people monitoring data integration;
-
Stakeholders who are less-database-savvy; and / or
-
DevOps-ish release / configurations management teams.
Some (not all) of these folks could benefit from access to SSIS Catalog Reports apart from access to the other stuff in SQL Server Management Studio (SSMS) – especially in Production. SSRS provides a browser-based and read-only view into the enterprise Production data integration environment.
Feedback is appreciated.
:{>
Love the idea, I would want a more Overview report of all executions without needing to provide an executionId.
Thx
Awesome. I am working on something similar. Ssis catalog has lots of info to monitor your etl process
Hi Per,
The Executions report provides part of an overview of the previous N executions. I could expand the data in the Overview report (or add an "Overviews" report) to include the previous N executions. Is that what you’re after?
:{>
Hi Andy, Great Reports!
Proposal when you host more projects on same ssis server:
Possible to filter executions by:
-Status
-Project
-Folder
-Package
Thx