Transformed .CSV file should not more than 1GB

Question

Transformed .CSV file should not more than 1GB

mohan.mariyappa

SSC Eights!

Points: 856
More actions
August 10, 2008 at 8:35 pm

#122850

I am generating .CSV file with just one column in it from a table. Here the issue is, I have to restrict .CSV file generated to 1GB. Once .CSV file generated is greater than 1GB, then I need to transform remaining data into different file name. Is this possible to do or is anyone tried to do this? Any help in this direction is greatly appreciated. Thanks in advance.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 1

Sure it is... you could do a running total of the length of each row +2 (for Cr/Lf) and key your export off that. See the URL below...

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

mohan.mariyappa SSC Eights! Points: 856 More actions · Answer 2

Thanks. I am relatively new here. Is ther a way is anyone send codes to do that or information secific to my problem? Thanks

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 3

Ummmm.... can't you at least give it a try on your own?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)