How to insert a new control flow task between existing tasks within an SSIS package?

Is it possible to insert a data flow task between two existing tasks in an SSIS package?

I have a data flow that is in pretty good shape. During testing the data flow logic, I found that I need an additional data flow task between existing ones.

Is 开发者_如何学JAVAit possible to insert a new task between the existing tasks?

Solution:

You need to delete the Precedence Constraint connecting the two Control Flow tasks and then drag and drop the new task between the two existing tasks. Connect the precedence constraint from the first task to the new task and the precedence constraint from the new task to the existing second task.

Precedence Constraint is the arrow between two control flow tasks that denotes the direction of the flow. The arrow could appear in green, red or blue colors depending on the condition used to direct the flow.

Caution:

If there is an expression on the Precedence Constraint, you have to note down what the expression is before deleting the precedence constraint. You may need to use that expression again after introducing the new task.

SSIS 2012 package illustrating the steps:

Assume that you have an SSIS package named SO_6115881.dtsx. Within the package, you have two data flow tasks on the Control Flow tab. Below shown screenshot indicates that there are not expression or constraints on the Precedence Constraint (green arrow).

If you had an expression defined on the Precedence Constraint, the letters fx will appear on the precedence constraint.

You can double-click the precedence constraint to view the Precedence Constraint Editor to make note of the expression used. Here, the precedence constraint uses the expression @[User::IsValid] == True to verify if the package variable @[User::IsValid] evaluates to true or not.

Let's assume that there are no expressions between the two existing control flow tasks. To delete the precedence constraint, you click on it and press Delete or right-click on the precedence constraint and click Delete.

After deleting the precedence constraint, drag and drop the next control flow task between the two existing tasks. Drag the precedence constraint from the task Data Flow Task 1 and connect it to the new task New Data Flow Task.

Drag the precedence constraint from the new task New Data Flow Task and connect it to the task Data Flow Task 2. You should now have the new control flow task successfully added in between two existing tasks. If you had an expression, double-click the appropriate precedence constraint to add the expression.