I have a SSIS that is importing a CSV file into a DB.
The SSIS I have it also looking at the file to see if the there any changes.
All this works.
But the problem is I need it to delete the ROW in the DB and insert the the new row with the updated data.
The DATE is the import thing I would like the SSIS to update any row that has data change.