pivot transformation in ssis

Question

Post reply

pivot transformation in ssis

prsnn_shetty

Right there with Babe

Points: 750
More actions
November 23, 2007 at 6:47 am

#200907

Hi,
I am trying to get data in form of pivot table in excel.My data source
is OLEDB.

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

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

vasile.t SSCommitted Points: 1636 More actions · Answer 1

there is a data flow pivot transformation in ssis:

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

patr SSC Eights! Points: 892 More actions · Answer 2

I dint understand how to use the pivot transform .....guys please help me out if there is link ...with pictorial representation.......

since am facing isseus while giving the lineage ids and pivot key values.......i have referred teh msdn link u have provided above...unfortunately it dint answer my issue

matthijs.vogt SSC Enthusiast Points: 134 More actions · Answer 3

there's an example of the pivot component usage here: http://sqljunkies.com/Article/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk

It doen't have screens but it's pretty clear on how to use it.