Phil Parkin (11/20/2014)
Change the properties of your lookup component so that its lookup is not cached.It will hit performance hard, but it should do what you want.
And change the OLE DB destination to not use the fast load as well. And still, if rows with the same customer name are in the same buffer...
This really has to be tested well. And it will be the slowest package in SSIS history 🙂
(I think using TSQL will be much more efficient here. Use DISTINCT and NOT EXISTS to get faster results)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP