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

Hello i-DLT,

DTS is a client app and therefore the data will flow right past the executor.

Try calling a job on Server A that calls the package.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Thanks a lot Allan!

"Allan Mitchell" wrote: