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 |
|
bnhcomputing
Starting Member
22 Posts |
 Posted - 2005-09-28 : 11:40:33
|
| I have designed a DTS package with several steps. All the on success paths work great. Hoever, when I introduce an error, execution stops but the failure path isn't followed. "Fail Package on first error" is not checked. Any ideas?Thanks in advanceHubert Hoffman |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-09-28 : 13:44:05
|
If you are running transact sql tasks which have multiple sql statements in them - the on fail will only check the last statement.Duane.  |
 |
|
|
bnhcomputing
Starting Member
22 Posts |
Posted - 2005-09-28 : 14:53:10
|
| I'll try to clarify:when an active-X vbscript task returns failure, I would expect the failure route from that script to be followed, however execution stops.Hubert Hoffman |
|
|
|
|
|
|
DTS Workflow (on failure) fails