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.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2010-02-18 : 10:39:22
|
| I need to import a 904-column dataset, from a flat file. My Excel 2003 seems to be inhibitored to 256 columns, where version 2007 gets past that.I was thinking of taking 256 chunks of rows, and merging those with a tool in SSIS. Is that viable?What about pivoting that so the 904 columns go vertically down, and then unpivot it once it's in a 904-column-capable environment? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-18 : 10:53:26
|
| 904 columns going vertically down is unpivoting and opposite is pivot.you may use pivot and unpivot transformation in ssis for that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS & Excel are Useless