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 2008.

SQL Server database environments are growing in size and complexity, fueled by rising data volumes and new business demands. At the same time, the challenge of maintaining the performance and ...