That's a bit over 1.6GB of memory you need to cache the lookup.
Maybe it's an issue when you run the package in 32-bit?
What if you execute the package in 64-bit?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP