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