• In SSIS you could use the <Slowly Changing Dimension> component which basically does the UPSERT.