February 7, 2013 at 8:37 am
Hi All,
I have a table with id and name as columns.... It has values like,
id Name
10 aaa
10 bbb
20 ccc
10 ddd
I want my o/p like
id Name
10 aaa,bbb,ddd
20 ccc
Can it be achieved through SSIS??
Thanks in advance,
Debanjan
February 7, 2013 at 9:43 am
Yes it can.
February 7, 2013 at 10:28 am
Can you please explain how it can be achieved??
February 7, 2013 at 10:32 am
SSIS has PIVOT transformation component for this kind of thing.
Alternatively you can use a SQL task component and use the T-SQL PIVOT command to transpose your table.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply