Updating data in your DB daily

• Timothy Moore

  SSC Veteran

  Points: 234

  More actions

  March 27, 2007 at 11:41 am

  #369933

  i have used the bulk insert to update all flat files into my database, however, i get a new flat file daily and need to somehow write a script to update that database with only NEW data. how would i go about checking whats in the database and then adding the new data? any help would be MUCH appreciated.

   

  thanks again

• Lynn Pettis

  SSC Guru

  Points: 442447

  More actions

  March 27, 2007 at 12:12 pm

  #697248

  Load the new file into a temp table, then use a query to select the data that needs to be loaded based on the primary key of the data.