A convenient way to do is using MERGE as that works based on target server condition and you can insert , update and delete in the destination table .

Put that command in your job and hopefully that will work out for you .

http://msdn.microsoft.com/en-us/library/bb510625.aspx