| Author |
Topic |
|
notes4we
Yak Posting Veteran
90 Posts |
 Posted - 2008-10-22 : 12:41:03
|
| Is there any way to execute all(about 10) packages that are in a project in a single package? To be more clear, I was wondering if there is any way where we can create a new package that helps in executing all the packages that we have at once. One package having 10 packages to execute.I do not wish to have sequence in the packages that are running. The packages should be executed randomly but as a single package.Please do let me know for further clarifications.Thank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-22 : 12:50:36
|
| Yup. You could create a master package which uses a for each loop container to loop through all the 10 packages and then use Execute package task inside loop to execute each of them. |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-22 : 12:54:05
|
| Or, just have 10 Execute Package on control flow without connections. That should fire all at once like fireworks! |
|
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-10-22 : 14:18:23
|
| Yes. I do not want any sequence, so I am trying to use an Execute SQL Task all independently. Lets see how it works. Thanks for your replies. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 00:21:42
|
quote:
Originally posted by notes4we
Yes. I do not want any sequence, so I am trying to use an Execute SQL Task all independently. Lets see how it works. Thanks for your replies.
though not simultaneously, you can get random sequence by using For Each Loop also. |
|
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-10-23 : 10:35:12
|
| I am trying to use 3 Execute Package Tasks independently, but I am getting an error in two tasks. When I run those packages individually, those are running fine.I was wondering if there is any change in the properties window (at the package level) that I need to make?Any help will be appreciated.Thank you. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 10:37:44
|
| whats the error info from progress tab? |
|
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-10-23 : 12:02:29
|
| Error: Error 0xC0012050 while loading package file "C:\Path\Package1.dtsx". Package failed validation from the ExecutePackage task. The package cannot run. . |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-23 : 12:52:38
|
quote:
Originally posted by notes4we
Error: Error 0xC0012050 while loading package file "C:\Path\Package1.dtsx". Package failed validation from the ExecutePackage task. The package cannot run. .
Are you storing package in filesystem and trying to run it from there? also is package actually stored in c:\path folder of your server? |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-23 : 12:53:04
|
| Try to set DelayValidation = TRUE on all the tasks and see what happens. |
|
|
|
notes4we
Yak Posting Veteran
90 Posts |
Posted - 2008-10-24 : 09:50:59
|
| Thanks. Delay Validation = True in all the Execute Package Tasks and Delay Validation = False(default) in the overall Package is working fine.Thank you once again. |
|
|
|
|
Run all the packages at once