SQL Server Integration Services (SSIS) - Event Logging

SSIS Event Logging

While troubleshooting your SSIS package or tuning your SSIS package for performance you need to know what SSIS Runtime Engine and SSIS Pipeline Engine are doing under the hood. For that purpose, SSIS provides Event Logging feature which traces the execution of SSIS Package and its components during its execution life-cycle. I have written an article covering all aspects of SSIS Event Logging, starting with what Event Logging is, it usage scenarios, its configuration and finally best practices to follow while using this feature.

Refer this link for more details.

https://www.sql-server-performance.com/articles/per/SSIS_Features_And_Properties_Part1_p1.aspx