Can SSIS execute tasks in specific order?

Question

HI

I am in process of creating an ssis package that need to do following in specified order:

1: process some data 2: move that data to some other tables 3: Get some data and push it in a plain text file.

I have created 3 store procedure for these, I have 2 "Execute SQL tasks" for 1 and 2 and a "Data Flow task" for 3rd.

Now when i run the package i can see all 3 step are completed (no errors) but they are not running in correct order.

I see step 3 is run first then step 1 and 2, i think then step 3 runs again. Normally i can ignore it but as the data in the text file can be 700 mb, i need to find a way to get SSIS to run these task in sequence.

I have tried "Sequence Container" but no luck.

Can some one help me with this please?

KA

Answer 1

You need to use precedence constraints to tell SSIS what order your tasks need to be executed in.

Drag the green arrow from task one to task two, and from task two to task three.

Answer 2

Hi

You could connect as

1. first SQL execute task

2. precedence constraint on success

3. second SQL execute task

4. precedence constraint on success

5. data flow

SSIS will follow the sequence as we required.

thanks

prav

Answer 3

The best is to use Sequence Containers... basically they help in creating a Sequence.

But since it does not work in your case, create Child Packages for all your different process and then create the Master Package which will have a link to those child packages, USE "Execute Package task"