sql server dts: concatenate in SSIS -- sql server dts

concatenate in SSIS

Billa
5/16/2007 12:43:18 PM

sql server dts: Hi,
I have following in put
person ID____________Choice
-------------------------------------
1___________________Apple
1___________________Banana
1___________________Peach
2___________________Lemon
2___________________Coconut

and I want to translate in following

person ID____________Choices
-------------------------------------
1___________________Apple, Banana, Peach
2___________________Lemon, Coconut

Any help will be highly appreicated

thanks in advance

Re: concatenate in SSIS

Allan Mitchell
5/16/2007 8:05:35 PM

Hello Billa,

You could use a Script component as a transform or a destination to do this.

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]