Wednesday, March 7, 2012

issue with dts.taskresult from script task

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