multiple server Query without linked server

  • 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,

  • How about SSIS? 🙂

  • 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

  • How about using OPENROWSET?

    OPENROWSET ( 'provider_name'

    , { 'datasource' ; 'user_id' ; 'password'

    | 'provider_string' }

    , { [ catalog. ] [ schema. ] object

    | 'query' }

    )

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply