maintaining history data of a table

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  March 5, 2009 at 8:24 pm

  #384084

  currently we truncate data in a table before loading the legacy data into the table. since we are truncating the data before loading, we do'nt have any history information for that table. What's the best way of doing this, without truncating the data as we want to keep

  history information in the table.

  Thanks!

• Bruce W Cassidy

  SSChampion

  Points: 12668

  More actions

  March 5, 2009 at 8:36 pm

  #954622

  [font="Verdana"]Er... stop truncating the table?[/font]

• Tim Mitchell

  SSCoach

  Points: 15684

  More actions

  March 5, 2009 at 9:15 pm

  #954631

  Same question also posted over at SQLTeam: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=121110

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices