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 |
|
PCJ
Starting Member
2 Posts |
 Posted - 2007-12-18 : 08:59:18
|
Hi All, I am woriking with a package wherein i need to export data from SS TABLE to excel sheet, however the no of cells exceed the 65536 which is the limit in excel, i tried using the pivot option in data flow transformation, however i am unable to do this, how do i go about doing this. Can someone tell me the correct procedure plzzzzz. Regards,Pratik |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-18 : 09:04:26
|
Well.... you could get office 2007, that version of excel has a row limit of somewhere around 1048576 rows  Duane. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-12-18 : 09:12:55
|
It depends on what you are trying to accomplish.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
EXPORTING DATA INTO A PIVOT TABLE