skaggs.andrew (5/6/2014)
This process is going to be used on a nightly basis. Not sure how I could use a raw file unless I had a process that created a new file for me in a directory, then used that file for the lookup. How would using a flat file help? Sorry, I am unfamiliar with using flat files in a lookup.
When you want to use a flat file as a cache, you need to use the cache connection manager.
This cache needs to be created be a seperate process.
Lookup - Using the cache connection manager
By the way, this cache is NOT the same as an SSIS RAW file.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP