Hi All, I have many Data Flow Ta

[Motlatjo]

Hi All,

I have many Data Flow Tasks that are running sequentially, i need to know if there is a way that i can make them run concurrently(Same time)

Thank you

 

[xlbo]

are they all in teh same package?
If so, simply remove your precedence constraints and they will run in parallel

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Motlatjo]

Thank you!!

 

[SQLScholar]

Becareful with a few things. Firstly locking - make sure you arent trying to use the same tables.

Secondly - loading them all together may not be quicker. For instance your hard disk will be skipping backwards and forwards between table writes (if you write to tables).

I always think its better to have a happy medium.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------