• Nice article and a good companion to Jamie Thompsons blog at conchango:

    http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx

    I see you followed the same development path as I had - generalise the error logging and then the same principle can be applied to all SSIS packages in production. This leaves you with a consistant process log table which can be used for system reporting.

    Handy when you want to run a quick report in the morning to check on the status of all the overnight jobs 🙂