Since our source data is on left side so we will use LEFT OUTER JOIN here and matches existing data from right. = Src_Customer Country) any of data does not matches then UPDATE.
There are multiple ways this can be done such as using link servers, replication, Table Diff utility, etc., but in this tip I am going to demonstrate one-way synchronization using an SSIS Merge Join.
I need to get NULL records from the right and left tables where the custid does not match and this will determine if we need to perform a delete or insert operation. I suggest you find the method that works best for your business needs.
As mentioned above the UPDATE (cust ID Match) condition, it returns the data where cust ID matches.
We don't know if the data has changed on the source, so to minimize updating every record I have added a conditional split that compares each column to see if any data is different.
If it is, then we will do the update and if not we will not update the record.