Hi All, I have flat file input as mention below ID |NO|Rnk|SP1|Sp2 0000177|01| 1| N|N 0000178|01| 1| P|P 0000178|01| 2| GP|GP 0000179|01| 1|ORS|ORS 0000180|01| 1| GP|GP 0000181|01| 1| GP|GP 0000181|01| 2| GS|GS 0000182|01| 1| GP|GP 0000183|01| 1| FM|FM 0000183|01| 2| CM|CM 0000183|01| 3| RM|RM and I want the O/p like ID|No|1|2|3 0000177|01|N|Null|NUll 0000178|01|P|GP|Null 0000179|01|ORS|Null 0000180|01|GP|Null 0000181|01|GP|GS|Null 0000182|01|GP|Null|NUll 0000183|01|FM|CM|RM But when I made one package using Pivot transformation but I got an error like "[Pivot [28]] Error: Duplicate pivot key value "1". Please Guide me.

Use a SORT transformation before the PIVOT transformation. Thanks

Did you set ID as PivotKey? follow instruction here for using PIVOT Transform in SSIS 2008: http://www.rad.pasfu.com/index.php?/archives/14-PIVOT-Transformation-SSIS-Complete-Tutorial.html http://www.rad.pasfu.com