when a pivot transformation is mostly used in real time?? Can someone help me regardingd the question??

http://msdn.microsoft.com/en-us/library/ms140308.aspx. Happy to help! Please mark the post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.

Pivot transform is used when you want to turn a set of values in a column into a list of columns in your output. For example, say you have the following Employee Salary data generated from some source:- Empname Month SalaryAmt ------- ----- --------- Jess Jan 120 Jen Jan 900 Aby Feb 600 Jen Feb 300 Dan March 1000 If you PIVOT the above data on a specific column, say "Month" then we'll have the values of "Month" column turned into individual Column nmaes and if we choose "SalaryAmt" to be the Value stored under them, the output will look like:- Empname Jan Feb March ------- ----- ---- ----- Jess 120 Jen 900 300 Aby 600 Dan 1000 You can learn about how to use the Pivot transform in SSIS to do this by readin about it on Reza's well documented blog here. Hope this helps. Cheers!! Muqadder.

thanq mugadder.u r have been very helpful.

you can find out a read world sample of PIVOT and how to implement it here: http://www.rad.pasfu.com/index.php?/archives/14-PIVOT-Transformation-SSIS-Complete-Tutorial.htmlhttp://www.rad.pasfu.com

it takes row values and converts them to columns, moving – but not aggregating - a value as it does so. Please check the James's Blog for more.. :) Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Hi For better understanding Pivot Transformation, use this link: http://www.youtube.com/watch?v=ZoCxAksokJM Hope this helps!!! Cheers! Sharath

Hi For better understanding Pivot Transformation, use this link: http://www.youtube.com/watch?v=ZoCxAksokJM Hope this helps!!! Cheers! Sharath

You can do dynamic PIVOT queries in T-SQL. Generally you are better off uploading data in proper normalized RDBMS table format and let queries or SSRS reports take care of the PIVOTING. Related article: http://www.sqlusa.com/bestpractices/training/scripts/pivotunpivot/ Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM