SSIS - Precedence Constraints

The green arrow represents On Success and means that the second (or downstream) task will only execute if the first (or upstream) task or set of tasks executes successfully.

--绿色箭头代表当上一任务成功后，执行一下任务

The blue arrow represents On Completion and means that regardless of whether the upstream task completes successfully or fails, the downstream task will execute. This is useful for a clean-up task, for example.

--蓝色箭头代表当上一任务完成后，不管成功或者失败，都要执行下一任务

The red arrow represents On Failure and means that the downstream task will execute only if the upstream task fails.

--红色箭头代表，当上一任务失败之后，执行某一个步骤

You can also place expressions on the precedence constraint. With this functionality, you can put code on the constraint that states that the expressions must be true, and optionally the constraint must be true as well. These are useful if you want to add conditions into your control flow.

--可以给控制流增加控制条件