This tutorial explains how lookups may highly decrease SSIS package performance and when they should only be used in Business Intelligence projects.