title: Split Large File into several smaller files using BCP Utility by line number
body: <p>I was hoping somebody might be able to help me out here or point me in the direction of some resources that could shed some light.</p>
  
  <p>I am using BCP utility to generate a large CSV file (~200 million lines) from SQL server.  </p>
  
  <p>I was wondering if it is possible to have BCP split the file (say every 10 million lines) while processing so that instead of having one large file I end up with 20 smaller ones?</p>
  
  <p>I know I could split the file after I create it, but this takes up quite a bit more storage space as I would duplicate the original file.</p>
  
  <p>Any help would be greatly appreciated!</p>
  
  <p>Thanks very much in advance.</p>
  
  <p>Mick</p>