DTS - How to update records using DTS

• Rohit

  SSC Veteran

  Points: 292

  More actions

  July 16, 2004 at 7:15 am

  #59839

  Hi

  I am using DTS to insert record on a daily basis, which deletes all the records and inserts it.

  I have a need to update change records only and insert new one for that day.

  How can I do that ?

  Help..

  
  RJPATEL
  

• conrad coetzee

  SSC Enthusiast

  Points: 112

  More actions

  July 16, 2004 at 7:36 am

  #514837

  If I understand you correctly:

  Use the ‘Transform data task’ to insert new rows and an update query in an ‘Execute SQL Task’ to update existing rows.

  Create a DTS package with ‘Execute SQL Task’ and ‘Transform data task’