Loading Flat File into SQL Server using SSIS
<p>New to SSIS and am trying to import a flat file into my DB.  There are 6 different rows on the flat file that I need to combine into one row in the database, each of these rows contain a different price for one symbol.  For example below:</p>

<pre><code>IGBGK  21 w  47 
IGBGK  21 u  2.9150  
IGBGK  21 h  2.9300    
IGBGK  21 l  2.9050   
IGBGK  22 h  2.9300      
IGBGK  22 l  2.8800 
</code></pre>

<p>So each of these are in a different rows on the flat file but will become one row in different columns for symbol <code>IGBGK</code>. I can transform the data to place each number into its own column but can not get them to combine into one row. </p>

<p>Any help on the direction I need to go with this is greatly appreciated.  </p>

<p>End product should look like:</p>

<pre><code>Symbol | col 1 | col 2 | col 3 | col 4 | col 5 | col 6
-------+-------+-------+-------+-------+-------+-------    
IGBGK  |  47   | 2.915 | 29.30 | 2.905 | 2.930 | 2.880
</code></pre>