开发者

SSIS how to fail package on parallel step failure?

Is it possible to stop SSIS package from running with a failure error if one of the parallel tasks in a package fails? Now if parallel task fails other tasks stil execute. Take a look at the pic开发者_如何学Goture. It runs despite of putting on 'True' on FailPackageOnFailure and FailParentOnFailure in the task Properties.

SSIS how to fail package on parallel step failure?


Personally, I would put the parallel tasks in a Sequence Container and flow from "1 Check Data" to the container then to "7 Reload"

SSIS how to fail package on parallel step failure?

If any of the tasks in the Sequence Container fail, the entire container will fail and execution will not move on the the Final task (unless specified to continue even if errors)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜