February 15, 2011 at 3:52 am
Hi All,
I've nearly 8 lakhs records available in a table, I need to transfer it to .csv file, when i do it using Data Flow Task --> Old DB Source - Flat File Destination, and open the .csv file from C:\Temp it throws error msg as File not uploaded properly and returns only 65536 records.
Now am in need of once sheet 1 is loaded then the remaining datas will be loaded to sheet2, sheet3, sheet4, etc,....
Pls help me to resolve this issue.:crying::sick:
February 15, 2011 at 3:58 am
If someone gave me a spreadsheet containing hundreds of thousands of rows on multiple sheets, it would be effectively useless to me. What is the requirement? Get users to open the CSV using another program. Or give them a summary of the data (=fewer rows). Or use Excel 2007.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 15, 2011 at 4:32 am
My requirement is like that, if that is effectively useless for you means not for all. Possible help me, else leave it.
Anyone else give me an idea to get datas in multiple datasheets.
February 15, 2011 at 4:38 am
umajanaa85 (2/15/2011)
My requirement is like that, if that is effectively useless for you means not for all. Possible help me, else leave it.Anyone else give me an idea to get datas in multiple datasheets.
You will find that people on this forum will often ask you for the reasons behind what you are trying to do. They do this because there are often better or more efficient ways of going about things than the original poster has even thought about. I did give you other options, but you appear not to have considered them at all and instead rather rudely told me to shove off. Not the best way to get help on a forum where people give up their time for free.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 15, 2011 at 6:15 am
Phil posted exactly what i would have...i would immediately question why your end users are using a tool to view data that is limited to 65536 rows of data;
The advantage of the forum is for you to learn from other peoples experiences (and mistakes)
you can export all the rows to the same old spreadsheet or csv file as before, and if the end users use the wrong tool to open the document, they get the expected, truncated view of the results. Like Phil said, if they open it in a different tool, whether EditPlus or Excel 2007+ or OpenOffice, that issue goes away.
I don't think that's the responsibility of the exported data to predict, and work around, a limitation that exists in the Chair-To-Keyboard-Interface
Lowell
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply