Why Monitor SSIS?

SSIS is a platform for data integration and workflow applications. It features a data warehousing tool used for data extraction, transformation, and loading (ETL). As a data warehouse, SSIS supports data analysis and acts as a conduit between analytical tools and operational data stores.

Many organizations rely on SSIS' data mining and porting capabilities to aggregate, manipulate, and export large volumes of business data to BI tools, so that useful business analytics can be derived and prudent business decisions can be taken. In such organizations, if for instance, package execution frequently fails / slows down / encounters errors, timely business decisions cannot be taken. This can sometimes cause the organization to suffer huge losses!

This is why, it is important that administrators monitor the key functions of SSIS - i.e., package execution and processing of data flow tasks - for errors and inconsistencies, capture anomalies rapidly, and eliminate these issues before they impact business continuity.