title: SSIS Lookup Component Performance Sorting Lookup Query
body: <p>I'm attempting to use the SSIS 2008 lookup component in full cached mode with a T-SQL Query.
  Is there any benefit to using a ORDER BY clause in the T-sql.</p>
  
  <p>Here is a example:</p>
  
  <pre><code>SELECT
   FooFK
  ,FooValue
  FROM dbo.Foo
  ORDER BY Foo;
  </code></pre>
  
  <p>In this case, I'm using FooValue to lookup the value of FooFk.</p>
  
  <p>Also will multiple Lookups component run in parallel? I think this was the case in 2005.</p>