Catalog Browser is free and surfaces SSIS Catalog projects and configurations metadata in a unified view.
Check out version 0.9 – compatible with SSIS 2019 and SSIS in Azure (Azure-SSIS in Azure Data Factory and Azure Synapse Analytics)! New in v0.9:
- Improved Catalog load performance
- Catalog Statistics
Updates in v0.9.12.4, v0.9.12.5:
- Bug fixes.
Updates in v0.9.12.0:
- References containing no reference mappings (environment variables referenced by project / package parameters) are now visible.
- All references found in a project or project artifacts – whether mapped or unmapped – appear at the project level:
Here’s a video to demonstrate using Catalog Browser to view mapped and unmapped references in an SSIS Catalog:
A feature I forgot to mention in the video is the “Check for Update” menu item:
If you are running the current version – beginning in version 0.9.10.0 – clicking Help>Check for Update will display a status message:
If you find you are not running the most current version of SSIS Catalog Browser, simply visit this page and Add Catalog Browser to your cart – it’s FREE!
Updates in v0.9.9.3:
- Updated queries to play nice with SSIS Catalog and SQL Server security.
When a user with public permissions (only) connects to an SSIS Catalog, SSIS Catalog Browser displays a bare minimum, as shown here:
When a user with SSIS Catalog Read and Read Objects permissions for a few SSIS Catalog Folders connects to an SSIS Catalog, SSIS Catalog Browser displays only folders for which they have read and read objects access, as shown here:
When a user with SSIS Catalog ssis_admin role connects to an SSIS Catalog, SSIS Catalog Browser displays all SSIS Catalog artifacts, as shown here:
One of the main reasons I developed and maintain SSIS Catalog Browser is the Values Everywhere feature. SSIS Catalog Browser surfaces SSIS Catalog projects and configurations metadata in a unified view for local instances of the SSIS Catalog:
SSIS Catalog Browser also connects to SSIS in the Cloud:
Click View–>Catalog Statistics to view metadata about SSIS Catalog objects: