Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

multiple server Query without linked server Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2008 5:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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,
Post #454811
Posted Wednesday, February 13, 2008 7:00 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 9:38 AM
Points: 1,157, Visits: 3,270
How about SSIS? :)

Tommy

Post #455021
Posted Wednesday, February 13, 2008 10:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Post #455204
Posted Wednesday, February 13, 2008 10:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 9:38 AM
Points: 1,157, Visits: 3,270
How about using OPENROWSET?

OPENROWSET ( 'provider_name' 
, { 'datasource' ; 'user_id' ; 'password'
| 'provider_string' }
, { [ catalog. ] [ schema. ] object
| 'query' }
)



Tommy

Post #455210
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse