Scenario:I have created an SSIS Package and have configured Event Handler on Package level. If any error occurs in any Task, I want to Send Email with Error Code , Error Description etc. It is working great. But each time SSIS Package fails, It send more than one email. How to get only single email if error occurs in SSIS Package?
Create an SSIS Package, I have created SSIS Package with two Data Flow Tasks inside Sequence Container as shown below