title: SQL Server : Bulk Insert 0 Rows Affected
body: <p>I'm new to SQL and I'm attempting to do a bulk insert into a view, however, when I execute the script the message says (0 row(s) affected).  </p>
  
  <p>This is what I'm executing:</p>
  
  <pre><code>BULK INSERT vwDocGeneration
  FROM '\\servername\Data\Doc\Test.csv'
  WITH
  ( 
      Fieldterminator = '|',
      Rowterminator = '\r\n'
  )
  </code></pre>
  
  <p>I've confirmed the row terminators in my source file and they end with CRLF. The view and the file being imported have the same number of columns. I'm stuck! Any ideas would be greatly appreciated!</p>