My approach would be to use a separate table on the database. If SQL server
allows temporary tables, create one in your cf template. Otherwise, create a
working table on your database, and, near the start of your cf template, run a
query to delete all the records.
Next, loop through your csv file and insert each line into the
temporary/working table. It might be easier to convert the file to a query
with cfhttp first, I don't work much with files.
Finally, it's two more cfqueries, one update and one insert.