Hi All
I have created a dataflow in SSIS which is using a lookup table of 11 Million record size..
I have to use this dataflow several times based on some parameters (For Ex: Different source tables.).. Everything else is same..
While running these dataflows parallely 'Caching'(Pre-Execute step) for lookup table is happening only once..
But if I am going by a 'For each loop' Task for calling these dataflows, this caching is happening each time when Dataflow is executed ...
Can any one suggest, how I can make this caching happens only once though I am calling dataflow several times???
Regards
Agson Chellakudam