Hi,

I am trying to confirm a hypothesis on the Network traffic that a certain
DTS will generate, my environment is configured as follows:

Server A: SQL Server Instance to act as source
Server B: SQL Server Instance to execute DTS Package
Server C: File Server at remote location to be target server

  If I run a DTS package in Server B to extract information from Server A
and generate a fixed length flat file in Server C. Is it valid to say that,  
all the information required to build the flat file will travel on my network
from Server A to Server B  first and then it will be dumped in the flat file
on Server C?

Is there any way to still use Server B to execute the DTS package but, have
the network traffic go directly from Server A to Server C?

Thanks a lot!

Ignacio