title: Convert rows to columns in SSIS. Unpivot?
body: <p>If I have data like this</p>
  
  <pre><code>"","",WAREHOUSE ID,1,2,3,4,5...
  "","",WAREHOUSE CODE,BOS,HOU,LAX,NYC,CHI...
  "","",WAREHOUSE NAME,BOSTON,HOUSTON,LOS ANGELES,NEW YORK CITY,CHICAGO...
  </code></pre>
  
  <p>But want to transform it like this</p>
  
  <pre><code> WAREHOUSE ID, WAREHOUSE CODE, WAREHOUSE NAME
   1,BOS,BOSTON
   2,HOU,HOUSTON
   3,LAX,LOS ANGELES
   ...
  </code></pre>
  
  <p>If, as above, [Column 2] is the column that contains what should be the header row, and Columns 3 through 40 contain what should be row values, which columns get selected and set to pass through for the UNPIVOT to perform the desired transposition?</p>
  
  <p>Or is UNPIVOT not even what I'm looking for?</p>