Ssis-948 Jun 2026

CorrectedOrderDate = ISNULL( OrderDate, ISNULL( DATEADD(DAY, -1, ShipDate), CAST(GETDATE() AS DATE) -- fallback to today ) )

[INFO] 2026-04-16 02:13:05 – Package started. [INFO] 2026-04-16 02:13:07 – Data Flow: 1,245,678 rows read. [INFO] 2026-04-16 02:13:09 – Derived Column applied. [INFO] 2026-04-16 02:13:10 – OLE DB Destination: 1,245,666 rows inserted. [INFO] 2026-04-16 02:13:11 – 12 rows redirected to FactSales_Rejected. [INFO] 2026-04-16 02:13:12 – Package completed successfully. ssis-948