title: How do I create this SSIS lookup in SSDT for VS 2012?
body: <p>I have a column in my data source named "Gender". Currently the column contains one of six possible values. I want to create a transformation that takes the value from the source and converts it to one of four standardardized values. How do I do this?</p>
  
  <p>So far I added the lookup transformation to the designer surface and checked the options. I think I can accomplish this with a simple SQL query, psuedocode below, but I'm not sure what I need to do or how to do it.</p>
  
  <pre><code>If Gender = M or Gender = 1 then GenderId = 1
  If Gender = F or Gender = 2 then GenderId = 2
  If Gender = U then GenderId = 3
  If Gender = X then GenderId = 4
  ... etc.
  </code></pre>
  
  <p>Thanks!</p>