Update table 1

[klewis10367]

I want to update a table on one server from a table on another server using dts where only new transactions are updated. I have brain farted and and have no idea howe to do it. Any help would be apprecited.

 

[unclerico]

First you'll need to add a linked server to the destination server

Then you would do something like this (pseudocode):

UPDATE a
   SET a.somefield = somevalue
  FROM table a
 INNER JOIN linkedservername.databasename.schema owner.tablename b
    ON a.field1 = b.field1
 WHERE b.transaction = 'Updated'

Is this what you are looking for or am I way off here?

 

[klewis10367]

Thank you. That refreshed my memory.