"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...
> > 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
>
>