title: How to do incremental load in SQL server
body: <p>I have DB tables where there are no identity column. We have client data fetched from DB2 to SQL Server and unfortunately DB2 design doesn't have identity columns.</p>
  
  <p>Now we have some data inserted, updated and deleted from source (DB2/SQL Server) and these data I want to load to destination (SQL Server) using some incremental load concept.</p>
  
  <p>I tried SSIS lookups in Dataflow task however it's taking huge time to simply insert one new record. Please note that, in "lookup transformation editor" I'm mapping all "available input columns" to available "available lookup columns " as there is no identity column. I think, this is why it's taking time. I have few tables having around 20 million records.</p>
  
  <p>Is there any faster method /ways available to do this, specially when table does not have identity column? Is except or SQL merge will help? </p>
  
  <p>I'm open to have any other approach other than SSIS.</p>