Helpful information and examples on how to use SQL Server Integration Services.
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