SSIS Catalog Browser

$0.00

Use Catalog Browser to view SSIS Catalog contents on a unified surface. Check out v0.9, compatible with SSIS 2019 and SSIS in Azure!

Categories: , Tags: , ,

Description

ALblue

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.15.0:

  • Bug fixes.
  • Project and Package Parameters Values Everywhere displays values for referenced parameter only, not for all referenced parameters in scope.

Updates in v0.9.14.0:

  • Bug fixes.
  • No longer mixing package parameter references with project parameter references in the Values Everywhere feature.

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:

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:


(click to enlarge)

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!