Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
8022421
Starting Member
45 Posts |
 Posted - 2008-12-24 : 11:10:12
|
| 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. |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-12-24 : 11:19:49
|
| Where are you handling OnError and OnPostExecute again? Package or task level; it makes a difference. |
 |
|
|
8022421
Starting Member
45 Posts |
Posted - 2008-12-24 : 11:52:23
|
| Package Level is it a Problem. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-12-24 : 12:07:00
|
| If package level OnError then the rest should not fire (well it depends). If it's the other way (OnPostExecute package level) then it will fire.Try emailing yourself with descriptive error message within event task and see if the helps you see where to trigger events happen. |
|
|
|
|
|
|
Event Handlers in SSIS(OnError & OnPostExecute)