I concur with the multiple columns logic and query performance improvement with EXCEPT.

I currently use Oracle's MINUS SET Operation (similar to EXCEPT) to compare all columns of ETL source...

I understand your timestamp column logic (now called rowversion 2008).

Makes sense to have a staging table at the OLTP data centers. SSIS is still in its infancy I struggle...