Getting Informative SQL Agent Notifications from Failed SSIS Packages


Introduction

The SSISDB database (a.k.a. the Integration Services catalog) was introduced back in SQL Server 2012 as a way to de-clutter the MSDB database and provide some built-in logging and reporting infrastructure. In a nutshell, SSISDB is an SSIS framework (see Fig #1) making SQL Server Integration Services more robust and enterprise-friendly by providing the following features:

Database backup Database encryption Support for environments Support project and package parameters Package versioning Custom SSRS performance reports built into SSMS Support for deployment within SSDT Fig #1 – SSISDB Database and Catalog

While overall SSISDB Catalog was and still is a great enhancement