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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2007-09-24 : 14:27:33
|
| Hi,Could some body show me an example of VB Script task that checks failure from an existing step (EXEC my_SP) and exit the package?All I found were the ones that will set MAIN = DTSTaskExecResult.Success after doing some checking. Basically I have several EXEC SP steps, then a transformation task. I want to detect failure of these sp and skip the transformation.Normally, I could make the failure links to send mail step, but in this case, that is not an option.Thanks! |
|
|
|
|
|
VB Script task to check failure