Andy Brownsword makes those SSIS jobs run faster:
Last week we looked at using a cache to improve lookup performance. We saw how a cache improves performance by being able to reuse reference data repeatedly. That used a regular cache but it’s not the only option available to us.
In this post we’re going to look at the File Cache option which can achieve the same results – plus a little more.
My experience with file caches is that they’re a bit finicky but when you get them running, they can provide a significant speed-up to data enrichment tasks.