83 Pivot in SSIS | Pivot Transformation in SSIS

[@reddyabhik]

super well explained about the pivoting in SSIS It is simple and great

[@learnssis]

Thank you for your appreciation.

[@gilbertoenriquetejadalema5242]

Excellent explanation. Thank you my friend. From Bogotá, Colombia

[@learnssis]

You are most welcome my friend.

[@gilbertoenriquetejadalema5242]

Thank you so much

[@ericsos101]

great content .. can you please make a video content on script component tansformation for pivot in ssis

[@DhanyaGowda-l9m]

Hi Akil, I have to implement a logic where excel has 5 columns 1st column has some datas other column data has X whereever X is marked I need to get the values of the 1st column

[@DhanyaGowda-l9m]

How we can implement in ssis or sql query we can write

[@learnssis]

@@DhanyaGowda-l9m First I would suggest you to import that data to a sql table, and then easily you can update data in sql table using an update query.

[@jeffersonromario5936]

Is there a way to order the dates?

[@learnssis]

Frankly speaking I have not used Pivot a lot, what I will do is that I will add a Sort transformation in between and will sort the data on Date column.