harun-974445 (3/24/2011)
Hi ,my question is which one is the best solution for performance optimization ?
One Multithreading DTS or
Many parallel job calling DTS simultaneously
Without trying to be flippant, it depends..
Also I assume you are refering to SSIS as opposed to DTS.
The first question I have is whether your process is structured so that parallel loads could function?
As far as a single table being loaded I wouldn't likely try to load it from more than one package at a time without some serious testing to find out if the additional processes overcome the additional overhead as well as making sure that we only try to insert the same piece of data once. I have seen this done where the additional package created enough contention that the load ran slower with two processes.
So unfortunately there will be no hard fast rule to answer that question..
CEWII