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 |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2009-05-06 : 19:05:41
|
| i apologize for posting twice on this issue but i am at a complete dead end with this issue. i will explain exactly what is going on: I have a standalone package which generates multiple errors. i have an onerror vb script (originally intended to collect error messages into a large string) but which how only has a msgbox for debugging. i have an onpost execute vb script (originally intended to email the collected error messages) which now also has only a msgbox for debugging. if there are 10 errors in the package the onerror and onpost execute script fire alternately one after the othererror 1: onerror then on post execute then error 2: onerror then on post execute etc. isnt the onpostexecute only supposed to fire ONCE at the END after the package execution is completed??? why would it fire after EACH error? can anyone explain to me what i am missing? How can i run a script ONCE at the end of a package AFTER each error has fired the onerror error script?? is there a different event other than onpost execute i should be looking for? |
|
|
|
|
|
onerror event and onpost execute event alternate