|
Home > Archive > MS SQL Data Warehousing > March 2006 > DTS Network Traffic
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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@microso
ft.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@microso
ft.com...
>
>
>
|
|
|
|
|