From the Lookup presentation I put together for the MS BI conference in October, here is a series of posts which describe different patterns for using the Lookup transform.
Each pattern will contain a diagram with Upstream and Downstream images.
These represent any collection of source / transform / destination components that could appear before/after the Lookup section described in the pattern.
The SQL Server Integration Services team added valuable new caching options (and scalability) to the