title: How to populate IDataReader from .csv for use with SqlBulkCopy.WriteToServer(IDataReader)
body: <p>Someone mentioned today that using the IDataReader version of WriteToServer (Note: Data is stored in a .csv file) would be quicker than using datatables for large .csv files. Unfortunately im struggling to find information on how this actually works/should be implemented.</p>
  
  <p>only link i found is below:</p>
  
  <blockquote>
    <p><a href="http://www.developerfusion.com/article/122498/using-sqlbulkcopy-for-high-performance-inserts/" rel="nofollow">http://www.developerfusion.com/article/122498/using-sqlbulkcopy-for-high-performance-inserts/</a></p>
  </blockquote>
  
  <ol>
  <li>Where is the data actually stored? </li>
  <li>Would i be importing one row at a
  time?</li>
  <li>How do you split about specific characters ie ',' in this
  case?</li>
  </ol>
  
  <p>Is this something which is quite tricky?</p>
  
  <p>Thanks</p>