ssis convert rows to columns
===

I have following structure now:

    SID	Prog_TYP
    1	504
    2	Free   
    3	ELL
    4	Sped   
    5	Free   
    6	Mobile 
    7	Sped   
    8	Free   
    9	HAL    
    10	Reduced
    10  Free

However, I need to convert it into following table 

![enter image description here][1]


  [1]: http://i.stack.imgur.com/X9gs5.png

How could I get this result in SSIS? Plz explain in details and especially welcome snapshots! Thanks for any solutions!