SELECT s.I2 AS SCEID, dci.CIKey, dt2.TimeKey AS EDate,         
dt1.TimeKey AS CycleMonth,        
ISNULL(CONVERT(MONEY,s.C1),0) AS AE1,        
ISNULL(CONVERT(MONEY,s.C3),0) AS AE2,        
ISNULL(CONVERT(MONEY,s.C4),0) AS AE3,        
ISNULL(CONVERT(MONEY,s.C5),0) AS AE4,        
ISNULL(CONVERT(MONEY,s.C6),0) AS AE5,        
ISNULL(CONVERT(MONEY,s.C7),0) AS AE6,        
ISNULL(CONVERT(MONEY,s.C8),0) AS AE7,        
ISNULL(CONVERT(MONEY,s.C9),0) AS AE8,        
ISNULL(CONVERT(MONEY,s.C10),0) AS AE9,        
ISNULL(CONVERT(MONEY,s.C2),0) AS AE10,        
ISNULL(CONVERT(MONEY,s.C11),0) AS PE1,        
ISNULL(CONVERT(MONEY,s.C12),0) AS PE2,        
ISNULL(CONVERT(MONEY,s.C13),0) AS PE3,        
ISNULL(CONVERT(MONEY,s.C14),0) AS PE4,        
ISNULL(CONVERT(MONEY,s.C15),0) AS TotalAE,        
ISNULL(CONVERT(MONEY,s.C16),0) AS TotalPE,        
dt.TimeKey AS ModifiedOn, @TimeKey AS TimeKey        
FROM dbo.Staging_SC s        
INNER JOIN dbo.DimCI dci        
  ON s.I1 = dci.SCConID        
LEFT OUTER JOIN dbo.DimDestinationTable dceh /*This is what is getting blocked */
  ON s.I2 = dceh.SCEID        
LEFT OUTER JOIN dbo.DimTime dt        
  ON CONVERT(SMALLDATETIME,s.LastUpdate) = dt.FullDate        
LEFT OUTER JOIN dbo.DimTime dt1        
  ON CONVERT(VARCHAR,CONVERT(SMALLDATETIME,s.D1),101) = dt1.FullDate --CycleMonth        
LEFT OUTER JOIN dbo.DimTime dt2        
  ON CONVERT(SMALLDATETIME,s.D2) = dt2.FullDate --EDate        
WHERE s.EntityType = 'CEHist' and s.I1 IS NOT NULL and s.I2 IS NOT NULL        
and dceh.DestinationKey IS NULL;