Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
on7june
Starting Member
41 Posts |
 Posted - 2008-07-31 : 02:37:13
|
| I am having a total of 10 packages in my solution. Where one package acts a parent package which executes the other nine packages from it using execute package task. All the packages are stored in the same location including the parent package. I first created 9 individual execute package task to carry out this process. Now i feel its not a good idea to use that logic since maintenance is cumbersome when the package size increases. So is it possible to use ForEachLoop container for this. (How i will exclude my parent package execution while using this since it is also stored in the same folder?) Please advice me.Sarvan |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-31 : 02:55:50
|
| I don't know how this loop is getting packages to run and it's order to run packages from 1 to 9.Maybe you can handle this by naming convention for packages to exclude packages named parent_...?WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
on7june
Starting Member
41 Posts |
Posted - 2008-07-31 : 03:15:56
|
| We can use a execute package task to execute the packages with in the ForEachLoop with the help of variables. Where the variables will be storing the package name using ForEachLoop. Any way thanks for your quick reponse.Sarvan |
|
|
|
|
|
|
ForEachLoop