Is logging in SSIS resource intensive? Should I use Event Handlers instead?Mr Shaw

I believe you should use a combination of both. It also depends on how much you log. If you log *everything*, it will be more of a hit of course. If you restrict to logging only the required information to base finding solutions to errors, you should not see a large performance hit from enabling logging and event handling. Event handling is also not the same level as ssis logging so you can get information that can be critical to problems to solutions out of both. of course, if you are running this on a phone (hardware restrictions) anything is an impact ;-)Ted Krueger Blog on lessthandot.com @onpnt on twitter Please click the Mark as Answer button if a post solves your problem!

In addition to Ted points. There should be trade off between our needs and the resource consumption. because, every task is resource consuming. I would like to add these in addition 1. Where exactly you are logging if it is SQL Server (transaction time), file system (IO performance), etc 2. Limit the logging with only specific event to save space and performance impact 3. Event handler in-turn consumes some resource and it is mainly used for error handling with in package (runtime) while your package in execution. so, choosing the feature is depends on the business need. Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com