I have a table as below: ID Field Value 1 FirstName Archive 1 LastName Zz 1 City NewYork 2 FirstName Mark 2 LastName Ashby 2 City NewJersey After using Pivot the table ID FirstName LastName City 1 Archive 2 Mark 1 Zz 2 Ashby 1 NewYork 2 NewJersey But I was Expecting result as ID FirstName LastName City 1 Archive Zz NewYork 2 Mark Ashby NewJersey And I want to get it through SSIS Pivot or any task any help will be grateful

Are you sure that the data coming in to the Pivot component is actually sorted in the order you've provided? If it isn't, then your results could be as you've shown. In order for your pivot to work properly, you need to sort by the ID column. The best walkthrough I've found to date on the Pivot is from BI Monkey. Talk to me now on

ya it is.

you didn't configured pivot transform correctly, you can achieve your desired result with pivot transform if you configure it correctly, this is a simple tutorial on pivot transformation which I recommend to you: http://www.rad.pasfu.com/index.php?/archives/14-PIVOT-Transformation-SSIS-Complete-Tutorial.html let me know if you have any further problem on configuring the pivot transformhttp://www.rad.pasfu.com