I need to do ETL/ data movement. The databases are located in two servers.
(e.g: Server_1 : 2 databases, Server_2 : 1 databases)

I am using stored procedures for ETL loads into staging tables. How do I
establish connection to different SERVERS using from my stored procedure.
can any body give suggestion ? All databases are SQL Server ?
Thanks in advance.

Linked servers will see you through this problem.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"baaul" <baaul (AT) discussions (DOT) microsoft.com> wrote

While it's not as desirable as using a linked server, you can also use
OPENROWSET or OPENDATASOURCE. Which one you pick depends on how you need to
use it. Both are in Books Online. The "not-so-nice" part of both is that
you have to put login credentials in the call. If you don't encrypt the
procedure, any user with access to syscomments will be able to read the login
and password used in the connection.


"Allan Mitchell" wrote: