have a script task that checks for existense of a file if found it sets
Dts.TaskResult = Dts.Results.Success and moves to next task
and if not found it sends an email then sets Dts.TaskResult = Dts.Results.Failure
but when I run the job to test for failure I do get the email but the job continues
to be in yellow state it never turns red. I have to terminate it myself manually.
Is there anything else I need to set?
Thanks in advance
I find that it is easier to set a boolean variable indicating success or otherwise. you can then check the value within a conditional precedence constraint.
-Jamie
No comments:
Post a Comment