Post reply

Running all the packages at once

  • October 22, 2008 at 10:41 am

    #199830

    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.

  • October 22, 2008 at 10:53 am

    #888227

    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

  • October 22, 2008 at 12:19 pm

    #888282

    Thank you Greg. I am trying to implement your suggestion. Sounds good to me.

    Thanks once again.

  • October 23, 2008 at 8:36 am

    #888639

    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.

  • October 23, 2008 at 8:47 am

    #888649

    Hi

    Waht error message are you getting? If you can post it we might be able to help 🙂

  • October 23, 2008 at 10:02 am

    #888710

    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