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:08 am

    #1596877

    Paul Hernández (3/14/2013)

    Hi Folks,

    I would like to know if it´s possible to use the T-SQL MERGE if the source DB is a DB2/AS4000 in a remote server, and the target is a SQL DB in the local server.

    Any comment would be appreciated.

    Kind Regards.

    I doubt it, given that DB2 SQL is a different language from T-SQL.

    Why have you posted this in the Integration Services forum, by the way?

    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.