title: Bulk insert, SQL Server 2000, unix linebreaks
body: <p>I am trying to insert a .csv file into a database with unix linebreaks.  The command I am running is:</p>
  
  <pre><code>BULK INSERT table_name
  FROM 'C:\file.csv' 
  WITH 
  ( 
      FIELDTERMINATOR = ',', 
      ROWTERMINATOR = '\n' 
  ) 
  </code></pre>
  
  <p>If I convert the file into Windows format the load works, but I don't want to do this extra step if it can be avoided.  Any ideas?</p>