I would suggest, load your flat file into a staging table first, then use Merge to insert/update records in your destination table.

Otherwise, you can use SCD transformation, but performance wise it is slow if your source has large amount of data.