Afternoon Folk.
Wanted to see if anyone has an answer to a DTS question I have. Here is The scenerio: I have a script that loads 7.5 million records into a fact table. When i run the script thru Query Analyzer(QA), it takes 33 minutes to run. If i take the same script and use it in a DTS "Execute SQL Task" and then run the DTS package, it finishes in under 17 minutes. Almost 1/2 the time. Can anyone explain to me the performance gain i see when using a DTS package over running the script interactively in QA?
Thanks
J. Kusch
Wanted to see if anyone has an answer to a DTS question I have. Here is The scenerio: I have a script that loads 7.5 million records into a fact table. When i run the script thru Query Analyzer(QA), it takes 33 minutes to run. If i take the same script and use it in a DTS "Execute SQL Task" and then run the DTS package, it finishes in under 17 minutes. Almost 1/2 the time. Can anyone explain to me the performance gain i see when using a DTS package over running the script interactively in QA?
Thanks
J. Kusch