Hi,

I have a DTS package which exports large amount of data
from Server1 (SQL Server 2000) to Server2 (SQL Server
2000) daily. Both the servers reside at the server room
and there is a direct network connection between Server1
and Server2. Both the servers have another LAN network
connection too.

My question is..how do I know DTS uses direction to
transfer data instead of LAN connection.

Is there a way to configure SQL Server DTS to use the
direct connection?

Thanks a lot for any assistance/guidance you may provide,
in advance.


Selvakumar

I guess you will need to use the IP address of the direct connection to try
and ensure that the direct cable is used as opposed to any other route. Do
not use a name as this could go either way.

The real question is how to force network traffic to use a particular
network route. This is networking, not my area I'm afraid.

--
Darren Green
http://www.sqldts.com

"Selvakumar" <rsk5d (AT) hotmail (DOT) com> wrote

First, thanks a lot for your response.

You mean, I have to specify the target sql server by IP
and NOT by the server name in the DTS package. Am I right.

Thanks.

In article <015c01c389d5$26abf9b0$a401280a (AT) phx (DOT) gbl>, Selvakumar
<rsk5d (AT) hotmail (DOT) com> writes
Yep, use the IP.

Using the name means it could resolve to either IP, so you have no
control.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

The Server2 with SQL Server 2000 has two IP address like
below:

192.168.15.62 - LAN
10.20.1.1 - DIRECT CONNECTION to the Server1

If I give LAN IP addres in DTS export package, DTS is
able to connect to Server2 BUT if I give IP address of
DRIRECT CONNECTION, DTS could NOT connect to Server2.

Is there any other option to make it work?

Thanks.

Can you make any connection down the direct connection?
Can you ping?
Can you use a file share?
Can you connect via Query Analyzer.
Is your SQL Server listening on the direct IP? Check the error log. If not
why not? Is this a cluster? Is the TCP/IP NetLib enabled?

Start simple, and ignore DTS until all the lesser tests work.


--
Darren Green
http://www.sqldts.com


"Selvakumar" <rsk5d (AT) hotmail (DOT) com> wrote

GOOD NEWS.

Now I am able to connect from Server1 to Server2 using
Direct Connction IP address.

I checked following as per your suggestion to make sure
basic connectivity is OK.

Ping was OK

Tracert was OK

File Share was OK

SQL Query Analyser Connectivity was OK

Then, I changed my DTS connection from server2's name to
IP address. It STARTED to work. I did not do any other
change in anything at all. But it seems to work now.

I will post my feed back soon I run my next data export.

Once again, thanks a lot for your assitance, Darren Green.

Selvakumar.

Hi,

I tested the data export couple of times and time taken
for the data export is almost the same.

Trying to expore more on this issue.

Thanks.

Selvakumar

Maybe the switched link is not very busy to start with, so the benefit of
using the direct connection is not really a factor. Maybe the network is not
the bottleneck.

Trying using Performance monitor to see what the load etc is like on your
network cards.

You could also try a network sniffer product to confirm that the traffic is
flowing the way you expect.


--
Darren Green
http://www.sqldts.com


"Selvakumar" <rsk5d (AT) hotmail (DOT) com> wrote