title: Validation before bulkinsert in sql server
body: <p>I want to import data from text file.which contain arround lakhs of records</p>
  
  <p>I am using bulk insert do it like this</p>
  
  <pre><code>BULK
  INSERT vw_bulk_insert_test
  FROM '\\server\c$\csvtext.txt'--\\server\SQLEXPRESS\csvtest.txt'
  WITH
  (FIRSTROW=2,
  check_CONSTRAINTS,
  FIELDTERMINATOR = '~',
  ROWTERMINATOR = '\n'
  )
  GO
  </code></pre>
  
  <p>But before insert I want to validate values of each column without using cursor.Like if second row will have values of all fields except unit_number(Column) then it should create a error log specifying unit_number value is missing.</p>