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 2000 Forums
 SQL Server Development (2000)
 File Split

Author  Topic 

cs_bhimavarapu
Starting Member

23 Posts

Posted - 2004-08-23 : 17:39:40
I have a large delimited text file with 90 million records. I am planning to split the file into 3 files to process them separately. I have searched for file splitters, and found only those which split the files by the size specified. My requirement is to split the file based on records and not on the file size.

Does any one have similar experience or suggestions for splitting the file based on records....

Thanks in advance

gpl
Posting Yak Master

195 Posts

Posted - 2004-08-23 : 18:18:53
I had a similar problem, I wrote a quick VB program to split a file into a number of smaller files - of a set number of lines, happy to mail you the code if you promise not to laugh.

Graham
Go to Top of Page

cs_bhimavarapu
Starting Member

23 Posts

Posted - 2004-08-24 : 00:52:26
Please if it is okay for you...

Thanks
Go to Top of Page
   

- Advertisement -