Ssis-308 [portable] -

She traced the source of RegionCode . It was a foreign key to a lookup table, Dim_Region , populated nightly by another SSIS package called RegionSync . Emma opened that package’s logs.

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