DTS Network Traffic

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
why dont you just have serverA execcute the DTS job straight to C?
"i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
> 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
|||They are on different newtorks and have different administrators, Server A's
security is much more strict than Server B which I administer.
"Immy" wrote:

> why dont you just have serverA execcute the DTS job straight to C?
> "i-DLT" <iDLT@.discussions.microsoft.com> wrote in message
> news:6871C29D-34CF-4D9C-85D8-FE08C3E420E9@.microsoft.com...
>
>