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!
   

- Advertisement -