Ssis-308 [new] -

She ran the same query directly in :

[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

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. She ran the same query directly in :