Re: DTS and the Internet
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 08/23/04
- Next message: Darren Green: "Re: How do you sort files in DTS?"
- Previous message: Darren Green: "Re: Can you copy tables in DTS without having to drop the destination table?"
- In reply to: dan: "DTS and the Internet"
- Next in thread: dan: "Re: DTS and the Internet"
- Reply: dan: "Re: DTS and the Internet"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Aug 2004 21:19:52 +0100
In message <OseOdhTiEHA.1776@tk2msftngp13.phx.gbl>, dan <dea@deamon.com>
writes
>I am using SQL Server 2000. The local computer is XP the remote one is
>W2003.
>I am the admin of both machines.
>I want to move data from the local server to the remote server over the
>internet, using DTS.
>Where and in what format should I declare to DTS the remote server.
>Thanks,
>Dan
>
Simplest way is to just add a connection for the remote server and
supply the IP address for the "name" and a SQL login username and
password.
You can use an alias created through the client network utility if you
want a nice way of specifying a friendly name, network library and port.
Then just use the alias name instead of the IP in your connection.
-- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org
- Next message: Darren Green: "Re: How do you sort files in DTS?"
- Previous message: Darren Green: "Re: Can you copy tables in DTS without having to drop the destination table?"
- In reply to: dan: "DTS and the Internet"
- Next in thread: dan: "Re: DTS and the Internet"
- Reply: dan: "Re: DTS and the Internet"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
