Home Forums SQL Server 2008 SQL Server 2008 - General Copy from Excel file into SQL table using BCP RE: Copy from Excel file into SQL table using BCP

  • March 7, 2014 at 5:03 pm

    #1695279

    tracmonali (3/7/2014)

    Thanks for information. Is there a way to write an SSIS which reads a table columns from one SQL server and transfers into another SQL server? I do not wish to use linked server. Can a query be used to join table columns across databases from 1 sql server and input as 1 table into db of 2nd sql server? Any thoughts appreciated

    Although there's no real performance penalty for joining across databases, there's a huge penalty for joining across databases on different servers. As Koen implied, the tables/data really need to be on 1 server and then you can push the data to another server much more quickly than doing a common join between tables on two different servers.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)