Best delta method

• peacesells

  SSCrazy

  Points: 2882

  More actions

  April 19, 2012 at 5:28 pm

  #255049

  I have a table with around 70 million records with around 20 columns. Now i need to develop delta logic using SSIS. Based on this scenario, i need to develop a package that only captures delta. what would be the best logic? rowversion,cdc, timestamp?? please advise thanks.

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  April 20, 2012 at 12:08 am

  #1476430

  It depends. What is your source system? Can it handle extra load such as the CDC process?

  Do you need to capture intermediate updates or only the final one?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP