Re: DTS and the Internet

From: John (jtaylor_at_kmznet.com)
Date: 08/24/04 

Date: Tue, 24 Aug 2004 14:06:03 -0400

Having never done this personally, I can only tell you what it sounds like
Darren is saying. Basically, go to Enterprise Manager, open the tree under
the Console Root folder, right click on SQL Server Group and select
New SQL Server Registration. Therein can you toy around with what
he's describing, I believe.

"dan" <dea@deamon.com> wrote in message
news:OwL204biEHA.644@tk2msftngp13.phx.gbl...
> 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
> >
>
>

Relevant Pages

  • Re: Merge Replication using ip address to distributor/publisher
    ... is no enterprize manager or client network utility. ... I also read that alias to ip address can be programmed in subscriber ... register the Publisher in Client Network Utility." ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Data Source connection fail
    ... In "SQL Server Client Network Utility", and in Alias tab I created a server alias with remote SQL Server IP address and port configured and "Network libraries" set to TCP/IP. ... I created a DTS Package and created a new "Microsoft OLE DB Connection for SQL Server". ...
    (microsoft.public.sqlserver.dts)
  • Re: sp_reset_connection needed?
    ... if you are not using Sql Server 7 there is _no benefit_ to ... common way to modify connection state is to do things like change database ... connections that are closed with a transaction active, ... This alias is for newsgroup purposes only. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Publishing SQL Server
    ... Have you changed the Default Network Library to TCP/IP in the SQL Server ... Client Network Utility? ... Please follow these steps to change the Default Network Library to TCP/IP ... If you need to configure an alias, ...
    (microsoft.public.windows.server.sbs)
  • Re: sp_reset_connection needed?
    ... > performance benefit to avoiding this call when using Sql Server 7. ... > common way to modify connection state is to do things like change database ... > connections that are closed with a transaction active, ... > rights.Please do not send email directly to this alias. ...
    (microsoft.public.dotnet.framework.adonet)
Loading