Can SSIS execute tasks in specific order?

Question

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.