Home > SSIS Best Practices > SSIS – Branching out, then in – the correct way

SSIS – Branching out, then in – the correct way

1. Desired task flow

Task A —-> Task B1 or Task B2 depending on the variable varIsSaturday —-> Task C

image

2. The above task flow is wrong

The above task flow will not execute the tasks in the desired order. The Task C actually gets executed before Task B1 or Task B2.

3. Correction: move Task C out of the container

image

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: