InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 20:28:28 GMT20http://www.sqlservercentral.com/Forums/Topic625436-148-1.aspxI understood your problem, even i faced the same problem.Where i used to store the results of OnError, OnPreExecute and OnPostExecute in SQL tables.So whenever a task execution starts, first it will fire OnPreExecute then insert a record into to Package_Process_table then fire OnPostExecute to update the Package_Process_table.In between if an error comes then it will fire OnPreExecute, OnError and OnPostExecute.In such case, OnError i will update Package_Process_table with status as FAILED, OnPostExecute first i will check whether the status of package is STARTED or FAILED if it is FAILED then i dont update Package_Process_table on OnPostExecute.Sat, 15 May 2010 04:37:03 GMTvidyasagar.kuntahttp://www.sqlservercentral.com/Forums/Topic625436-148-1.aspxHi, I am using a SSIS package to write the records to the flat file destination. During this process I am using Event Handlers [b]OnError[/b] and [b]Onpostexecute[/b] events. The OnError Event Produces a Failure Trigger file in my work area if any task fails.The OnPostExecute event triggers a Success trigger file when the task is completed. When an error occurs in any task, the onError event will get triggered which produces a Failure Trigger file. but again the on post execute event get triggered which even produces the success trigger file.In this case, I am not able to figure out whether it is a Success trigger or Failure Trigger. As because the OnPostExecute Event fires after the OnError Execute.Can you please help in this.Wed, 24 Dec 2008 09:07:17 GMTdhanasekar.palani