Bill Galashan (7/12/2010)
Anything wrong with the event handlers already available within SSIS. It is very simple to set up an SSIS template with the event handlers coded to generate logging, thereafter use this template as the basis for all new SSIS packages and a developer can then ignore logging as it is all built ready to go.
Good article, but I'd have to go with Bill on this one and say why not use event handlers. They provide so much more in terms of logging functionality.
The fact that you've gone to such lengths to create this logging functionality seems to indicate that you are not fully aware of the features available in the product you're using. Maybe you need to do a bit more research and planning before diving into the development end. Probably could have saved yourself some development time and produced a much more robust, adaptable system.
Take a quick look over this article Custom Logging Using Event Handlers by SSIS Guru Jamie Thompson, for quick look at the functionality.
--------------------
Colt 45 - the original point and click interface 