Matt Miller (1/30/2008)
I'm not sure I understand why you say lookup wouldn't work with a text source (or a text reference). Albeit slower thanks to the lack of indexing, I don't see why it wouldn't work. Once you set up the source and/or the reference file to appropriate read said file, what does the internal structure of the file have to do with anything?
A lookup component needs an OLEDB source for it's reference data. It cannot use a flat file.
Regarding the indexing, by default a lookup component caches everything and once the cache is hot, external indexing means nothing. It's internal to the SSIS engine. If you use partial caching, then the index on the lookup query is critical.
Data from anywhere can "flow over" a lookup component. However, the component needs to get it's refernce data from OLE DB.
CrispinI can't die, there are too many people who still have to meet me!
It's not a bug, SQL just misunderstood me!