Hi
I have many data pump tasks all included in a linear sequence and
involved in a transaction.
The last task commits or rollbacks the transaction.
I am trying to include a task after this last one on package failure,
with its corresponding precedence constraint "on failure".
But... the package does not FAIL indeed, because it is included in a
transaction so it is just "Not Run", is not the same thing.
I have been reading many related topics but I cannot find the answer.
The last task I want to include is an "Execute SQL Task" which will
send an email but it is not a "Send Mail" task. So first I have to
solve the problem of execution of the task and then pass to it
information about the rollback or whick task caused the rollback.
I would really appreciate some help and sorry if the English is not the
best, I am not native english speaker.
Thanks in advance!

Brenda.-