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 Integration Services (SSIS) has superseded DTS in SQL 2005 and has some great new features beyond better performance, more scalability and an integrated debugging facility. As if that was ...