The November CTP for SQL Server 2008 introduced our new Lookup Transform. 2005 packages with lookup components will upgrade automatically when opened/run in 2008, and should function the same as they did in 2005 with one minor caveat.
In certain scenarios, dataflows containing lookups with matching SQL queries would implicitly share a cache. As this implicit sharing was somewhat error prone, it has been removed in 2008. To share a lookup cache, you can now use the new cache connection manager.
For more info about the 2008 lookup changes, you can take a look at Jamie Thomson's write up.
PingBack from http://geeklectures.info/2008/01/08/no-more-implicit-lookup-cache-sharing-in-katmai/
Improved Scripting SQL Server 2008 (Katmai) introduces VSTA as our new scripting engine, which replaces