Home Forums Data Warehousing Integration Services T-SQL Merge over databases in different servers RE: T-SQL Merge over databases in different servers

  • March 14, 2013 at 3:46 am

    #1596891

    Paul Hernández (3/14/2013)

    Hi Phil,

    Thanks for your quick answer.

    Then I will create a temporal table to store the records to be update, and then perform a batch or bulk update, I think it is the best option since use a "OLE DB Command" component is too slow.

    I posted it here, because this issue is a part of an ETL proccess and I´m comparing loading strategies, but it could also be posted in the SQL Server 2008 forum.

    Kind Regards,

    Sounds like a good option. I think you meant 'temporary' rather than temporal. If not, I'd like to know how you would use a temporal table here.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.