Back in June 2005 I published what I consider to be one of my more useful blog posts amongst my plethora of inane ramblings, "SSIS: Custom Logging Using Event Handlers".
Josh Twist took the idea and ran with it. He realised that my use of Execute SQL Tasks was fraught with the danger of using copy and paste as a method of code reuse and hence has formulated a SSIS Custom Task to do exactly the same thing. More than that, he has shared the code on his blog post "SSIS Custom Logging Task for Event Handlers".
Great work Josh, this will be really useful to people that are utilising eventhandlers to build their own custom logging mechanisms.
-Jamie