Re: DTS and the Internet
From: dan (dea_at_deamon.com)
Date: 08/24/04
- Next message: Jacco Schalkwijk: "Re: Data checking problem..."
- Previous message: Jordan Green: "Exchange Server SQL Server communication Adding Appointment Entry"
- In reply to: Darren Green: "Re: DTS and the Internet"
- Next in thread: John: "Re: DTS and the Internet"
- Reply: John: "Re: DTS and the Internet"
- Reply: Darren Green: "Re: DTS and the Internet"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Aug 2004 10:39:07 +0100
Darren,
Thank you very much for your reply.
Unfortunately I am new to SQL and DTS thus I would need more guidance.
I tried to find in Books Online HOW to do what you suggested but it's
hopeless. For instance the only "add a connection" topic is related to
English Query.
I would be very grateful if you could give me more details.
Thank you very much,
Dan
"Darren Green" <darren.green@reply-to-newsgroup-sqldts.com> wrote in message
news:FmtGFDWoFlKBFwdq@sqldts.com...
> 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: Jacco Schalkwijk: "Re: Data checking problem..."
- Previous message: Jordan Green: "Exchange Server SQL Server communication Adding Appointment Entry"
- In reply to: Darren Green: "Re: DTS and the Internet"
- Next in thread: John: "Re: DTS and the Internet"
- Reply: John: "Re: DTS and the Internet"
- Reply: Darren Green: "Re: DTS and the Internet"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
