Post reply

Tasks calling sub-packages still in parallel?

  • March 21, 2006 at 10:20 am

    #112058

    Hello all,

    After encapsulating repetitive logic and tasks in sub-packages (since we don't have re-usable task objects yet), at run time they will be called by several other packages running from a "master" package. Will all the execute package tasks in the master still run in parallel?

    I'm hoping the sup-packages are loaded into memory as new objects each time they are needed by the various other packages involved.

    thanks in advance!

    Skål - jh

  • March 22, 2006 at 2:27 am

    #628030

    Each of the packages will operate as seperate processes so yes, they all execute in their own area in memory (depending on the ExecuteOutOfProcess property).

    As far as the calling package is concerned they are all seperate packages.

    There are a few concurrency issues. e.g. Without some fudging they would both all try and use the same checkpoint (if you are using checkpoints) and that will cause a locking problem on the checkpoint file (I have a pending blog post about this very subject - to be published soon). By and large though, you should be OK.

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • March 22, 2006 at 6:54 am

    #628074

    Great to know.  thanks a million!

    Skål - jh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply