Can you help me solve the following?

Daily we are loading results to a table that has 5 key fields. It is a simple transformation from a csv file to the database table.

Occasionally the data is preliminary or incorrect in the csv file and needs to be reloaded (primary idenitfier here is date). I want to modify the existing Package to over-write/replace the existing records.

As should be obvious If I try to run the SSIS package with data from the same date I get a key violation and the package fails.

The date key field is in the csv and in the data table; it is not in the file name.

I am not sure of the best way to "check" to see if the data exists first, then delete it if it does, so a reload can occur. We are only talking about a couple hundred small records.

The date key field is in the csv and in the data table.

Thanks
Gregg