Practical Business Intelligence Solutions using the Microsoft BI Suite of Tools provided along with Microsoft SQL Server
Add a script component to the error handler within the package and pass the error message as a readonly variable.