The Cache Transformation allows you to build up your lookup cache before you need it, saving you a step or two in the process. The Lookup transformation in SSIS has changed a lot in SQL Server ...