Ssis-308 - [new]

Emma checked the and saw:

SELECT TransactionID, TransactionDate, Amount, RegionCode FROM dbo.Fact_Transactions WHERE TransactionDate >= DATEADD(DAY, -1, GETDATE()) She right‑clicked . The preview window opened— zero rows . That was odd. The OLTP database was humming with activity; the finance team swore they’d entered dozens of new transactions the previous evening. ssis-308

[06/13/2026 01:45:12] Warning: SSIS Warning Code 0xC0047013 at Lookup [RegionLookup] : The lookup operation returned no matching entries for the following keys: (RegionCode = 0). A warning, not an error. But now she was seeing a cascade of NULL region codes, which caused the RevenueRollup package’s to fail when FailComponentOnError was set to True . The package then threw SSIS‑308 , bubbling up the failure to the job. ssis-308