Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  import excel pivot ssis unpivot

Author  Topic  nozix Starting Member 1 Post Posted - 2014-05-15 : 11:06:42 I am trying to pivot the table to sql server 2008 R2. source excel file is like this. date 1/1/2000 2/1/2000 money 5 7 name Julie tom I want to make the first column on the top row as a column names. date money name 1/1/2000 5 Julie 2/1/2000 7 tom how do I do this? is it possible? ssis pivot transformation? SQL code? thank you!