Description
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! New in v0.9:
- Improved Catalog load performance
- Catalog Statistics
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:
Here’s a video to demonstrate using Catalog Browser to view the contents of an SSIS Catalog:
Values Everywhere
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:
Catalog Statistics
Click View–>Catalog Statistics to view metadata about SSIS Catalog objects:
Got 3 minutes? Click here to learn more about SSIS Catalog Compare right now!