March 21, 2006 at 10:20 am
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
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
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