In your SSIS package, you can calculate the key-date (use script component and write some VB.NET), then issue a delete statement deleting all records that match that date (by using the expressions feature of the SQL Command task to change the statement on the fly) (doesn't matter of they exist or not, a delete that matches zero records is fine, so you can execute this always). Then import your new data.