开发者

SSIS how to fail package on parallel step failure?

开发者 https://www.devze.com 2023-04-11 17:55 出处:网络
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开发者

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

精彩评论

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