Frustration and rewards on using SSIS Pivot and Unpivot

Granted, if you are just transforming data in the same SQL server, why would you do it in SSIS instead of just using Pivot and Unpivot in T-SQL query?  But what about in the case where data comes from various sources?

What I had fun doing was the ability to skip using Linked server, pull in data from different sources, like XML over web service.  Another point that made me happy was the ability to simulate ROW_NUMBER() function with the merged data by using a Script Component.

Anyway, I highly recommend everyone to try this out.  It's very frustrating throughout the process, but the result is very rewarding. 

Pivot:  http://msdn.microsoft.com/en-us/library/ms140308.aspx

Unpivot:  http://msdn.microsoft.com/en-us/library/ms141723.aspx

Print | posted on Friday, May 20, 2011 3:36 PM

Feedback

No comments posted yet.

Your comment:





 

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski