Retrieving failing package and error message in SSIS

Question

I want to make a general error handling package that should be called from my other packages when something goes wrong. In this error handling package I want to log what task failed and the reason for the failure. How can I retrieve this information?

I'm using the Control Flow Failure precedence constraint to point out a Execute Package Task that executes the error handling package when something goes wrong.

Solution

I've done it, the only thing I needed was the executionid and the logging in a sql server so I could run a query like this:

SELECT event, computer, operator, source, starttime, endtime, message FROM sysdtslog90 WHERE (executionid = '?') AND (event = N'OnError') ORDER BY starttime DESC