On Failure Not Working

[Waynest]

Hi

SQL 2000 Ent Ed.

In my dts I have an execute SQL task which truncates a non-existent SQL table (I'm trying to force a failure).

From this task I have an 'on success' condition to another SQL task and also an 'on failure' condition to a SQL task which creates an email failure notifcation.

When I execute the dts it stops at the first task as I want it to, but it doesnt run the 'on failure' task.

The task which sends the email message works ok if I run that task manually.

What could be wrong???

Thanks

 

[dbomrrsm]

Just tested this myself - exactly as you describe it above and it works for me - the email sent on the failure of an SQL tast to Truncate a non existent table.

DBomrrsm

 

[Waynest]

Well, found the problem.

The second (and there are others too) task also had an 'on failure' condition to the same email task.

I've changed the DTS now so that all the tasks have an individual email failure task.

Would have preferred to have just had the 1 failure task though