Execute package one by one using SSIS

Hi,

I have created four package, it should executed sequencely one by one. Is it there any option like sequencer in Data Stage for achive this requirement? I want to execute these package one by one using SSIS. could you help on this requirement?

Thanks & Regards
S.Nagarajan

How about a new package that contains four Execute Package Tasks, each pointing to one of the four existing packages. Link the four tasks with workflow constraints, to force the execution order.|||

Thanks. guide me or give me samples for using workflow in SSIS

Regards

S.Nagarajan

|||Select a task, you will see the little green arrow hanging down. Drag the arrow to the next task.|||

The workflow controller in SSIS is what you see in the Control Flow tab in SSIS Designer in BIDS. Its simply a case of dragging arrows between tasks.

For slightly more advanced stuff, here's a great example of conditional workflow: http://www.sqlis.com/default.aspx?306

and another one of implmenting logical OR in your workflow: http://www.sqlis.com/default.aspx?308

-Jamie