|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, May 13, 2010 3:06 PM
Points: 3,
Visits: 9
|
|
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,
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 PM
Points: 1,148,
Visits: 3,148
|
|
How about SSIS? :)
Tommy
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, May 13, 2010 3:06 PM
Points: 3,
Visits: 9
|
|
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
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 PM
Points: 1,148,
Visits: 3,148
|
|
How about using OPENROWSET?
OPENROWSET ( 'provider_name' , { 'datasource' ; 'user_id' ; 'password' | 'provider_string' } , { [ catalog. ] [ schema. ] object | 'query' } )
Tommy
|
|
|
|