Event Handlers in SSIS(OnError & OnPostExecute)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Event Handlers in SSIS(OnError &...

Event Handlers in SSIS(OnError & OnPostExecute)

Rate Topic

Display Mode

Topic Options

Author

Message

dhanasekar.palani

Posted Wednesday, December 24, 2008 9:07 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, September 15, 2011 1:18 PM
Points: 22, Visits: 152

Hi,
I am using a SSIS package to write the records to the flat file destination. During this process I am using Event Handlers OnError and Onpostexecute 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.

Post #625436

vidyasagar.kunta

Posted Saturday, May 15, 2010 4:37 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:51 AM
Points: 1, Visits: 60

I 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.

Post #922458

« Prev Topic | Next Topic »

Permissions