We are using Fuzzy lookup transformation in our SSIS package.
We have selected option to store and maintain index for first time. And for subsequent executions, we use option to use existing index. So it will not create new index each time. We are doing fuzzy lookup on single source table with single column. The source
table contains more than 2.5 million rows.
So while executing the package, although its not taking time to build complete index. But still it takes considerable time and uses large memory whenever we execute it.
We have also set the WarmCache option to true. Although all data is loaded into memory and removed after execution.
Is there any other way so we can keep the data in memory, so for subsequent execution, it gets result directly from memory?
Please let me know if you have any suggestion? Its urgent.
Thanks in advance.
View Complete Post