SQL Server 2005 Integration Services (SSIS): Custom Logging Using Event Handlers
This article, from Jamie Thomson, is a very clear and concise introduction into customised SSIS package logging, using Event Handlers. Jamie takes you through the steps involved and provides an example you can download. All the supporting SQL is provided, making getting up and running with this new technology a breeze.
You'll fing the article here @ http://blogs.technet.com/industry_insiders/articles/407125.aspx