Where to run the package? -
11-11-2009
, 05:44 AM
Hi all,
I am executing a DTS package from a C# application that runs on the IIS.
The database used, is on different machine.
My question is, will i gain performance by executing the package locally on
the database machine.
When a package is not executed locally, is there data traffic between the
database machine and the executing machine?
Thanks,
Sharon. |