How to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure;
-
Hi, I am writing an SSIS Package, want to stop all the remaining tasks if I get Dts.TaskResult as failure (I am checking if file exists in Script task), I am trying different options like assigning false value to another variable etc, so far no success, can somebody suggest me the best way to stop execution of remaining tasks if a Script task gets failure result, any idea would be greatly helpful. thanks in advance friends. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
-
Hi, I am writing an SSIS Package, want to stop all the remaining tasks if I get Dts.TaskResult as failure (I am checking if file exists in Script task), I am trying different options like assigning false value to another variable etc, so far no success, can somebody suggest me the best way to stop execution of remaining tasks if a Script task gets failure result, any idea would be greatly helpful. thanks in advance friends. Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
Hi friends, Its easy, create a Boolean or some other type variable, assign that value accordingly in the script task, then after the script task, you can have more than one Precedence Constraint Editor, in that, take the Evaluation Operation as either expression or expression and Constraint etc according to your needs then set the expression with your variable that you have assigned in the script task, now after the script task it will either continue with next steps or it will go to the task you have assigned after the failure constraint. This is all it is, thank you SSIS and thanks for all the friends who tried to help or support me. :) Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."