connecting to two databases in SQLServer

[Michael Lee <homestoremike@YAHOO.COM>]

Hello,
I need to select data from one database and insert
into a table in a second database.  I'm on a SQLServer
2000 platform and would like to use SQR to perform
this task.

I want to eliminate the need to have one SQR output
the flatfile and one SQR to read the flatfile to
insert into the target database.

Can this be done, and if it can, how so?

Thanks in advance,

Mike


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com