In database I have a table with 2 columns
name code
-------------
mike abc
mike abc
mike abc
mike edf
mike xyz
Gail xyz
George abc
George xyz
flatfile should look like this
------------------------------------
xmnty mike abc edf xyz
xmntt mike abc
xmntt mike abc
xmnty Gail xyz
xmnty George abc xyz
For first code I will have static value xmnty,for same name and additional same code go to next row assign static value xmntt,for same name different code go to next column.
Please if you can provide sql query or give me instruction how to do it in SSIS.