I have the following data coming in to SSIS
Set Value
--- -------
1 One
1 Two
1 Three
2 Four
2 Five
2 Six
I want to transform it to read
Set ValueList
--- -------
1 One, Two, Three
2 Four, Five, Six
How do I do this in SSIS?
See Question&Answers more detail:os