Synchronizing Azure staging database with production

Question

Hi, I have a Azure staging database with tables being getting populated from an SSIS pacckage from external source. I need to have an implementation to synchronize the staging tables with the production tables. The schema of the staging and production tables might not be the same. Also some staging tables might not have the 'LastModified' date field to indicate whether the particular row was being changed or not. So the only way to track the change is to visit all the values in the columns.

What kind of solution could I implement to acheive my goal, MS Sync framework or SSIS, or something else?

Thanks, KS