Running all the packages at once
-
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.
-
You can create a 'master' package that has 10 ExecutePackageTasks, one for each package you want to execute. Then, you can just execute the 'master' package.
Greg
-
Thank you Greg. I am trying to implement your suggestion. Sounds good to me.
Thanks once again.
-
I am trying to use 3 Execute Package Tasks independently in a new master package, 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.
-
Hi
Waht error message are you getting? If you can post it we might be able to help
-
Error in the progress tab is:
Error: Error 0xC0012050 while loading package file "C:\Path\Package1.dtsx". Package failed validation from the ExecutePackage task. The package cannot run. .
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply