So, the data is never sent to (or pulled from) the target server? I thought that was what you needed in the first place. I thought your requirement was to update both servers so that the data was in sync
Update happens only at Target..not the source. Once we write this query on Source, we can move the data into Target and load it directly by comparing it to Primary Key....no need of doing a special compare to any of the values on target!!!