hi guys i need suggestion or links or anything will help at present am using two event handlers at package level , on error , on postexecute on post execute will insert data (like pacakge name, pacakge id, machine name, starttime.....) into table on error will update on table using packageid as search condition , it will just update error code and error description for those rows first question i am i doing in a right way second question when pacakge finished , how to update that table with status of true and failed with status of false in that table right now am using sql staments in execute sql task with parameter mapping

Hi, Please have a look into the following URL: http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/1593.aspx Cheers, Zaim Raza.

Hi, Try this one as well... http://colinkirkby.blogspot.com/2007/02/ssis-writing-to-event-log.html -- Sathish

hi guys i need suggestion or links or anything will help at present am using two event handlers at package level , on error , on postexecute on post execute will insert data (like pacakge name, pacakge id, machine name, starttime.....) into table on error will update on table using packageid as search condition , it will just update error code and error description for those rows first question i am i doing in a right way second question when pacakge finished , how to update that table with status of true and failed with status of false in that table right now am using sql staments in execute sql task with parameter mapping The Link provided above will help you.. apart from that your you want to capture package status pass or fail. for success you need to define another event handler at the last task of your package onPostExecute Event of same task. and in that event handler wirte sql statement to update the status as Success. and for Failure you need to define another event handler at package level (package may fail at any task) and write sql statement to update package status as failed this event handler will be OnError Event refer to below post which discuss about similar problem http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/0e4928c5-0eb8-46c8-9b30-93a4b1c11701Shailesh , Please mark the post as answered if it answers your question.

thanx