SQLTeam.com | Weblogs | Forums

How to handle/trap package validation error in SSIS


I have a SSIS package with in package one of connection manager is pointing to SQL server instance and test connectivity is successful and package is running fine from last few months.

But we have changed server name which is referring in connection manager and connection manager is went to offline mode. When we try to run the package we got package validation error. This makes sense.

But our intention is we have to send email communication even in case of package validation error. Can we handle package validation errors as part of event handlers?