February 12, 2008 at 5:04 pm
Hi,
I have two servers S1,S2.
I am currently connected to S1 but I want to Query a table from S2 without creating a linked server.
Is it possible.Can someone please post some information on how this can be accomplished.
ETL, Lookup ,Stored procedure anything is ok. I am using SQL Server 2005.This is a very urgent requirement.
Please help!
Thanks,
February 13, 2008 at 7:00 am
How about SSIS? 🙂
Tommy
Follow @sqlscribeFebruary 13, 2008 at 10:08 am
I need to write this logic inside a Stored Procedure. Can you please give some input son how can we write this SSIS inside a procedure. I am aware of the GUI based SSIS but not sure how to code it manually.
Thanks
February 13, 2008 at 10:19 am
How about using OPENROWSET?
OPENROWSET ( 'provider_name'
, { 'datasource' ; 'user_id' ; 'password'
| 'provider_string' }
, { [ catalog. ] [ schema. ] object
| 'query' }
)
Tommy
Follow @sqlscribeViewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply