How to excute package in sequence

How to excute package in sequence . i have an requirement like this the package should execute in a sequence

1.PKG1

2.PKG2

3.PKG3

and in some case PKG1,.PKG2,.PKG3 shoule run parallel.

Thanks & Regards

Jegan.T

Jegant wrote:

How to excute package in sequence . i have an requirement like this the package should execute in a sequence

1.PKG1

2.PKG2

3.PKG3

You know what the Execute Package Task is right? Well you can control the execution of these 3 packages from another package.

1. Put 3 Execute Package tasks into a new package. Point them at your 3 packages

2. Put a precedence constraint from Execute Package Task for PKG1 to Execute Package Task for PKG2

3. Put a precedence constraint from Execute Package Task for PKG2 to Execute Package Task for PKG3

Jegant wrote:

and in some case PKG1,.PKG2,.PKG3 shoule run parallel.

Well in this case...

1. Put 3 Execute Package tasks into a new package. Point them at your 3 packages

2. Drop an empty sequence container onto your new package

3. Drag a precedence constraint from teh sequence container to each of the three Execute Package Tasks.

-Jamie

|||

Hi Jamie

Thanks for your reply . ill try this and get back to you.

Jegan.T