title: SSIS Lookup Multiple Columns in one table to the same ID column in another
body: <p>I have the following table:</p>
  
  <pre><code>EventValue | Person1           | Person2    | Person3     | Person4       | Meta1  | Meta2 
  -------------------------------------------------------------------------------------------
  123        | joePerson01       | samRock01  | nancyDrew01 | steveRogers01 | 505   | 606
  321        | steveRogers02     | yoMama01   | ruMo01      | lukeJedi01    | 707   | 808
  </code></pre>
  
  <p>I want to transform the Person columns into IDs for my destination table, so all of the ID's would be coming from the same <code>Person</code> table in my Destination DB:</p>
  
  <pre><code>ID | FirstName | LastName  | DatabaseOneID | DatabaseTwoID
  ----------------------------------------------------------
  1  | Joe       | Person    | joePerson01   | personJoe01
  2  | Sam       | Rockwell  | samRock01     | rockSam01
  3  | Nancy     | Drew      | nancyDrew01   | drewNancy01
  4  | Steve     | Rogers    | steveRogers01 | rogersSteve01
  5  | Steve R   | Rogers    | steveRogers02 | rogersSteve02
  6  | Yo        | Mama      | yoMama01      | mamaYo01
  7  | Rufus     | Murdock   | ruMo01        | moRu01
  8  | Luke      | Skywalker | lukeJedi01    | jediLuke01
  </code></pre>
  
  <p>With results like so:</p>
  
  <pre><code>MetaID     | EventValue | Person1ID | Person2ID | Person3ID | Person4ID
  ------------------------------------------------------------------------
  1          | 123        | 1         | 2         | 3         | 4
  2          | 321        | 5         | 6         | 7         | 8
  </code></pre>
  
  <p>I currently have a Lookup Transform looking up the first Person column, but couldn't figure out how to convert all 4 Person columns into IDs within the same lookup. </p>