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.

Just know that this will most likely result in a table or clustered index scan.  Depending on the query and indexes you may get a non clustered index scan.

First, you should probably be working with your DBA to figure out what is going on.  Not much we can do over the internet since we don't have access to...