title: SSIS 2008 Lookup - Getting Started
body: <p>Using SSIS 2008 R2, I have an OLE DB source with around 30 fields.  Ultimately my destination is an Excel spreadsheet however I have a number of transformations along the way, including Lookups, Derived Columns, Data Transformations and Script components.</p>
  
  <p>At the moment I am stuck on Lookups.</p>
  
  <p>In my source data I have 6 columns where the value needs to be replaced with a value from a lookup table.  There are 6 different lookup tables, each with it's own key.  (The lookup tables are not related to each other).</p>
  
  <p>My understanding is that I need to include 6 lookup transformations in the data flow however I am having difficulty getting started.</p>
  
  <p>In the lookup transformation editor:</p>
  
  <ul>
  <li>General: Left the defaults</li>
  <li>Connection: Specified my OLE DB connection manager, and my (2-column) lookup table</li>
  <li>Columns: Here's where I get stuck.  I have availabe inputs, and available lookup columns, but no way to show the relationship between them.  What am I supposed to configure here?  I can specific a lookup column, a lookup operation, and an output alias.  But how do I relate the input to the reference table???</li>
  </ul>
  
  <p>Any assistance is greatly appreciated!</p>