Comparison vs Synchronization
We receive an Excel spreadsheet from a 3rd party which an SSIS package imports into a table. We then want to compare the table with the production server to determine what differences have occurred. As the Excel spreadsheet doesn't include our identity column we cannot just replace the table.
I have successfully created a comparison which uses a supplied unique key in the spreadsheet and correctly identifies the differences. Some of the differences are not important to the comparison but are required in the table. I have managed to exclude the columns in the comparison so we are only seeing the important changes.
The problem I'm facing is with the synchronization script. When updating and inserting rows, the columns that are not in the comparison are left out.
Is there a way to get columns that aren't in the comparison included in the synchronization?