Row Transpose to column using SSIS

Question

Post reply

Row Transpose to column using SSIS

ishaan99

SSCertifiable

Points: 6261
More actions
April 5, 2011 at 10:26 am

#248225

Does anyone has any link or details on how Data displayed in rows can be transposed into columns using SSIS. Ex if i have a table
as TEST1 cols are
ProgName Progct
Prog110
Prog220
Prog330
Prog120
Prog230
Prog340
I have another table as TEST11 with structure as
create table test11
(prog1 varchar(10),
prog2 varchar(10),
prog3 varchar(10))
The output in TEST11 should look as
Prog1 Prog2 Prog3
10 20 30
20 30 40
Any help on this will be greatly appreciated. Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

anand_vanam SSCrazy Points: 2376 More actions · Answer 1

anand_vanam

SSCrazy

Points: 2376

April 5, 2011 at 11:33 am

#1307613

Use PIVOT transformation

ishaan99 SSCertifiable Points: 6261 More actions · Answer 2

thanks yeah i know pivot transformation can be used but just wanted to see how thats set up in SSIS.

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 3

IIRC, it's known as a "Matrix" in SSIS and doesn't actually require the use of PIVOT but will have the same affect.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Anjan Wahwar SSCommitted Points: 1617 More actions · Answer 4

ishaan99 (4/5/2011)
thanks yeah i know pivot transformation can be used but just wanted to see how thats set up in SSIS.

This might help you-

http://www.databasejournal.com/features/mssql/article.php/3646531/SQL-Server-2005-Integration-Services---Part-38---Pivot-Transformation.htm 😎

__________________________________________
---------------------------------------------------
Save our mother Earth. Go Green !!!