Data between two sql registrations

Hi how can i set a query to retrieve data from 2 registrations ?
i am using the default sql server registration and an mdf database that i
connected. The data are distributed to the two databases.
Can anyone help me please ?Makis
Do the databases reside on the same Server?
If they do ,please run
INSERT INTO DataBase1.dbo.Table (....)
SELECT ... FROM DataBase2.dbo.Table2
"makis" <sera@.mind.gr> wrote in message
news:O54VPFaIGHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi how can i set a query to retrieve data from 2 registrations ?
> i am using the default sql server registration and an mdf database that i
> connected. The data are distributed to the two databases.
> Can anyone help me please ?
>|||Are those two SQL Server instances? Then use sp_addlinked server to create a
link between the instances, then by using properly qualified identifiers
(look up "identifiers" in Books Online) you can access data in either of the
databases (tables, etc.).
ML
http://milambda.blogspot.com/|||If "registrations" are meant with different servers, you have to
use/configure a linked server. Then you can extend the syntax from uri
by the following:
INSERT INTO Servername1.DataBase1.dbo.Table (....)
SELECT ... FROM Servername2.DataBase2.dbo.Table2
(four part notation)
If one server is local you sure can leave one Servername{0} out.
HTH, Jens Suessmeyer.|||Yep , I was by this statement
>The data are distributed to the two databases.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1138189932.137989.39870@.g44g2000cwa.googlegroups.com...
> If "registrations" are meant with different servers, you have to
> use/configure a linked server. Then you can extend the syntax from uri
> by the following:
> INSERT INTO Servername1.DataBase1.dbo.Table (....)
> SELECT ... FROM Servername2.DataBase2.dbo.Table2
> (four part notation)
> If one server is local you sure can leave one Servername{0} out.
> HTH, Jens Suessmeyer.
>|||the databases are in one server.
I meant that the data are spread accross the two databases.
I believe your query will help me, thanks for your help. Will post again if
any problems.

Cutting & Pasting Tasks

Has anyone else experienced serious pain when cutting and pasting tasks between packages? In that, the default way SSIS lays out the tasks is absolutely atrocious (things on top of each other, way to far apart from each other, boxes sized to small, etc.) Is there some trickery I need to do to get it to retain the layout and formatting when I paste?
Its rubbish isn't it? I also hate the way auto-format can sometimes produce a worse layout than what you started with and there's no way of CTRL-Z-ing it.

Sorry, that's not very constructive is it? I've fed this back to MS and am hoping its on their list of things for Vnext.

For the time being Greg, I think you're stuck with it.

-Jamie

P.S. CTRL-Z is something I'd like to see across the board but I dare say you need Visual Studio hooks in order to do this - so its a VS problem!