Optimizing syncing of large dataset between 2 servers with SSIS
You want to add a &quot;lookup&quot; operator in your SSIS pacakage.
this package will &quot;check&quot; for some columns (your PK for example) and you will then be able to take action on only the rows that are missing.