You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a Data Flow task that copies several million rows. The data flow requires a match against a reference…

You are designing a SQL Server 2008 Integration Services (SSIS) package. The package includes a Data Flow task that copies several million rows. The data flow requires a match against a reference table that contains 10,000 rows. Each row in the reference table will be used during the data flow. You need to ensure that the data flow executes in the minimum amount of time. Which data flow component should you select?