Ssis998 'link' [FREE]

: Leverage advanced features in SSIS 998, such as parallel processing and data caching, to improve performance and productivity.

To speed up performance, it can cache the reference dataset in memory, which is much faster than querying the database for every single row. ssis998