Parallel tasks and conections -
09-13-2006
, 03:30 PM
I am a newbie to DTS. Just yesterday I read about parallel execution of
tasks. Now I have, now, about 12 packages to run in a batch. So I
thought "What an opportunity to use parallel processing!". So I read
this group to discover the limits. From today's reading, I have
concluded that four is the magic number. I also read that each task
should have its own connection. So I start of the first four with
their connections. When these four are finished, I can start the next
four. How can I reuse the same connections that created for the first
four?
Does someone have a diagram or image of the workflow that will show how
I connect the dots?
I can see the first four, connecting the conections to the next four
without fouling up the processing order is the question. How about
this? If I create another icon for each of the connections and reuse
the names, it will be the same connection and I won't have to draw
lines that may mess up the workflow. Is this correct?
Thanks in advance,
IanO |