O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SSIS reports and catalog views

SQL Server 2012 comes with extensive integration with SSRS reports in different locations to support useful information for SQL server users. Some of these reports relate to Integration Service Catalog.

Integration Service Catalog reports are some standard reports which show execution status of packages, their validation status, connection manager's status and every operation done under the Catalog. These reports are useful for SSIS administrators who are responsible for maintaining SSIS packages, and also useful for SSIS developers who are responsible for part of deployment and execution for troubleshooting.

In this recipe, we take a quick look at SSIS Catalog reports and see their information provided.

Getting ready ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required