| Author |
Topic |
|
notes4we
Yak Posting Veteran
90 Posts |
 Posted - 2008-10-27 : 08:58:12
|
| I have created about 10 packages having 1 config file for each. So, there are 10 config files for 10 packages.I had created a job that ran these packages, but it was taking too long. So, I decided to create a master package that consists of all these 10 packages.So, not I have a master package with 10 Execute Package Tasks in it and everything is running fine. It is taking shorter time as compared to the job. But now, I have a question regarding the config files.The config files for each of these 10 packages is different and I want to keep those as it is in the master package also as there are chances that we might use the config files a lot in the future.I wish to create another job that will just run this master package (which has 10 packages in it), and I even wish to keep the config files. But I do not understand how can I mention those 10 config files in this master package.Any help would be greatly appreciated!!!!! |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-27 : 09:50:26
|
| Can't you just schedule a job to run this master package? Not sure why you need new package to run the master package. Maybe I'm missing the point of your question. |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-10-27 : 11:40:05
|
| Do I get this right? Your end product will be:Job that kicks off the > Master package that executes > 10 packages that have > 10 different Config FilesWhat's not working there?---http://www.ssisdude.blogspot.com/ |
|
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-10-27 : 13:39:07
|
quote:
Originally posted by igorblackbelt
Do I get this right? Your end product will be:Job that kicks off the > Master package that executes > 10 packages that have > 10 different Config FilesWhat's not working there?---http://www.ssisdude.blogspot.com/
Yes, you are right. But then my question is can I mention those 10 config files in a single job? |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-27 : 16:23:34
|
| Still not sure why you are worried about 10 config files. If master package runs okay (ie executed from IDE) then scheduling job should work the same, unless servers are in different locations (then modification may be necessary). |
|
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-10-27 : 16:45:13
|
| Yes the servers are in different locations and I will need to make the changes in the future, and that is the reason why I am so much concerned about the config files.For now, I have created 10 jobs for 10 packages as one job was taking too long. So may be it will speed up a bit if I run all the 10 jobs parallely each to execute one package only. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-27 : 17:01:49
|
| Setting config files with different server locations is common. Someone should have input to that part here.A different twist with a different approach - what if you schedule each 10 packages separately but run it at the same time and see if performance is okay. Just a crazy thought.** Disregard my comments if I'm off base. I'm confused now; it must be Monday. |
|
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-11-05 : 08:31:52
|
| Yes. I just read your post. But you will be surprised that we reached to this decision of creating 10 seperate jobs last week. And we have a trigger that runs all the jobs at the same time and this is considerably taking very short time.Thank you. |
|
|
|
|
Config file for Execute Package Task