我应该如何规划数据流任务以符合我的条件？ [英] How should I plan the Data Flow Task to go in sequence with my conditions ?

问题描述

有3个名为A，B，C的DFT（数据流任务）。我有A和B的情况，DFT将独立执行。但是第三个C DFT将在任何A或B完成后开始。

条件：

如果先完成，则无需等待B或如果B先完成则无需等待A，只需开始执行C.



我尝试过优先但不能达到上述最后条件。



如果有任何错误，抱歉。我是SSIS的新手



先谢谢了.....

There are 3 DFT(Data Flow Task) named A, B, C. I have a situation like A and B DFT will execute independently. but the third C DFT will start after completion of any A or B.
Condition:
If A complete first then no need to wait for B or if B complete first then no need to wait for A, just start the execution of C.

I have tried the Precedence but not able to achieve the above last condition.

Sorry if any mistake. I am newbie in SSIS

Thanks in Advance.....

推荐答案

我搞清楚了。



我们必须添加优先级并稍微自定义。

对于DFT_A，我们必须添加完成优先约束。在优先约束编辑器中选择评估操作表达式或约束。这将检查任务是否完成或条件是否满足。



对DFT_B执行相同操作并选择多个约束作为逻辑OR。



这将在两个优先条件下实现或条件。



它是......

I figure it out.

We have to add the precedence and customize it little bit.
For the DFT_A we have to add the completion precedence constraint. in precedence constraint editor choose Evaluation Operation Expression or Constraint. This will make check that task is complete or condition is satisfied.

Do the same for DFT_B and choose "Multiple constraints" as Logical OR.

This will implement the or condition in two precedence condition.

That it is......

这篇关于我应该如何规划数据流任务以符合我的条件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！