Just a quick post to link to an SSIS article posted on the sqlperf blog - Getting Optimal Performance with Integration Services Lookups