I'm new to SSIS. I'm trying to create a Package that will transfer data from one DB to another one. I created the UPSERT task for each table using using Slowly Changing Dimension. It works pretty good!
The only thing is how to handle records that were deleted from origin. If I guess correctly it will reinsert them in destination.