Home Forums SQL Server 2005 T-SQL (SS2K5) Best approach for Data transfer of large number of rows RE: Best approach for Data transfer of large number of rows

  • April 3, 2014 at 9:51 am

    #1702935

    Megha P (4/3/2014)

    ok...thanks..SSIS will be fast over script in case of different server data transfer?

    Yes, because with scripts you would have to use linked servers. SSIS will be faster.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP