If all you want are the data columns where data is different between two rows of data, which could mean different columns for different sets within the entire set, you...

Well, with nothing to test it against myself, I guess I will have to believe what you say.  Logically, however, I would disagree.  The first two CTEs should pull the...

I am making an assumption that "dbo"."SYN_STG_ODS_SAP_FI_GL4_DELTA_KEY" is a synonym for [ODS_SAP_FI_GL4_DELTA_KEY] shown...

Just out of curiosity does the following work?

DECLARE @Date1 DATE = '2018-06-04'
        , @Date2 DATE = '2018-06-01';

WITH DateCriteria1 AS (
SELECT
  [emp1].[RRD]
 ...

Duplicate post.  Please post any responses here: https://www.sqlservercentral.com/Forums/1969401/Alternative-for-Checkpoint-in-SSIS

You are welcome.