I forgot most of my DTS skills but since you have not received any responses I'll make a general suggestion:

Instead of loading the data directly into your target table, load the data into a staging table using the current 'copy columns' method and then issue an UPDATE...JOIN to update your target table from the data in your staging table.