Data go through the machine running DTS package?

#1

For example, I start the DTS import/output Wizard on my workstation C. And I
let the Wizard transfer tables in S1 to S2. Will all the data be transfer
from S1 to C and then to S2? or directly from S1 to S2?

So is it better run the dts wizard on S1 or S2?
The task manager shows dtswiz.exe use a lot of CPU and network traffic on C.

#2

Hello nick,

DTS is a client app so the data flows through the location of the computer
opening the package as you suspected.

Allan

Quote:

For example, I start the DTS import/output Wizard on my workstation C.
And I let the Wizard transfer tables in S1 to S2. Will all the data be
transfer from S1 to C and then to S2? or directly from S1 to S2?

So is it better run the dts wizard on S1 or S2? The task manager shows
dtswiz.exe use a lot of CPU and network traffic on C.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Data go through the machine running DTS package?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Data go through the machine running DTS package? - 01-05-2006 , 10:57 AM

Re: Data go through the machine running DTS package? - 01-05-2006 , 02:40 PM