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
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
