User269602965 posted
You can use SYSTEM.IO FILE STREAMING
to read each line to the end of the line delimiter (most files it is Carriage Return Line Feed)
and write out that line to a file,
looping every 10 lakh records to start a new file.
It is very fast in C# or VB.NET, even for 1 Crore rows.
