April 5, 2011 at 10:26 am
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
Prog1 10
Prog2 20
Prog3 30
Prog1 20
Prog2 30
Prog3 40
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
April 5, 2011 at 11:33 am
Use PIVOT transformation
April 5, 2011 at 12:32 pm
thanks yeah i know pivot transformation can be used but just wanted to see how thats set up in SSIS.
April 5, 2011 at 5:15 pm
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
April 6, 2011 at 12:24 am
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-
__________________________________________
---------------------------------------------------
Save our mother Earth. Go Green !!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply