Wednesday, March 7, 2012

DTS - On Failure send mail does not work

Hi

Task A is a Execute Package task, and Task B is as Send Mail task. They are connected with a 'On Failure' connection.

The problem is that when task A fails, task B is not run. Why?

I have enabled and disabled the 'Fail package on step failure' for task A and it's 'child' in every way possible. I allowed transactions, and then tried again with them of...

Suggestions?

Thanks in advance.
__________________
Joo MartoHave you verified that the event is in fact failing ? Create an on success flow with the same step and see what happens.|||With on success it works... but the log status of the task is failled!

How can that be?|||does this happen when ur failure step is the mail task? or it doesnt matter?|||Check if you have On Success report Failure.|||Try making Task B an activeX script or sumthin else and c if that works...

also check in ur execute package task when the package fails ie, how many steps in the package need to fail for the package task to fail...i think the default is 4 steps but u shud check what it is for ur package|||Busy day - sorry for the delay. Modify the package's property to "fail package on first error" - I am referring to the package that you are executing in execute package.|||Originally posted by rnealejr
Busy day - sorry for the delay. Modify the package's property to "fail package on first error" - I am referring to the package that you are executing in execute package.

Thankyou very, very, much

No comments:

Post a Comment