Post reply

connect two different tables

  • May 8, 2012 at 5:15 pm

    #273746

    How do you connect two tables from different servers (linked server is not possible because one of the table is from SAP)?

  • May 9, 2012 at 12:58 am

    #1484897

    I haven't worked with SAP enough to tell you about Joining tables from SQL server with SAP tables. But you can import data from SAP into SQL Server USING SSMS or USING SSIS and then do the JOIN.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

  • May 9, 2012 at 1:05 am

    #1484900

    vinu512 (5/9/2012)

    I haven't worked with SAP enough to tell you about Joining tables from SQL server with SAP tables. But you can import data from SAP into SQL Server USING SSMS or USING SSIS and then do the JOIN.

    Thanks for the tip Vinu. Does anybody know/have experience creating linked server using SAP ?? It is possible?

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

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