title: Can't BULK INSERT Into SQL Table From CSV File
body: <p>I seem to be unable to run a bulk insert on a SQL table from a CSV file that gets sent through FTP to our server. It runs without error, but alters 0 rows.</p>
  <p>If I copy the data into another file, it works, but I need to be able to do this automatically without messing with the file myself. Opening them both, the only differences I can see are that the line breaks are CRLF on the new file, and just LF on the original. Encoding looks to be the same as well on both, so I must be missing something not in the other similar questions asked.</p>
  <p>Sample script below:</p>
  <pre><code>    BULK INSERT dbo.t_process_order_import
          FROM 'C:\Root\Product Data\H888 ProcOrd.csv'
          WITH
          (
              FIRSTROW = 2, -- as 1st one is header
              FIELDTERMINATOR = '|',
              ROWTERMINATOR = '\n',
              TABLOCK
          )
  </code></pre>
  <p>Sample CSV Data:</p>
  <pre><code>ProcessOrder|ProductNumber|MaterialDescription|OrderQuantity|WorkCenter|StartDate|StartTime
  001001101111|000000000000101111|TEST|40500.000 |CKET02|20201014|220000
  001001221111|000000000000101111|TEST|14124.000 |GHFD02|20210225|032000
  </code></pre>