SQL Server 2008: Lookup Transformation and Caching In theory, using a Lookup transformation in SQL Server 2005 Integration Services is faster than trying to achieve the same goal with a SQL query. If Explore