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 |
|
Jayaseelan
Starting Member
6 Posts |
 Posted - 2008-10-27 : 10:03:58
|
| I am creating two trigger files a Success trigger file and a failure trigger file,The Failure Trigger file get created onError Event Handler the success trigger file gets created onPostExecute.But when ithere is an error in the execution on the package, I am seeing both the trigger file gets generated. Do the OnpostExecute event will get triggered after the onError Event.Is there any way i can stop without the execution of OnpostExecute Event(Creation of success trigger) when there is an error. |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2008-10-27 : 20:59:24
|
try posting your triggers, you might have a logic error. You can do anything at www.zombo.com |
 |
|
|
|
|
|
OnError Event & OnPostExecute Event