title: sql server - bulk insert error
body: <p>I am using bulk insert and getting below error:</p>
  
  <p>Note: The data in the load file is <em>not</em> beyong the configured column length</p>
  
  <h1>Running Command:</h1>
  
  <p>bulk insert load_data      from 'C:\temp\dataload\load_file.txt'       with (firstrow = 1, fieldterminator = '0x09', rowterminator = '\n',MAXERRORS = 0, ERRORFILE = 'C:\temp\dataload\load_file')</p>
  
  <h1>Contents of load file:</h1>
  
  <pre><code>user_name   file_path   asset_owner   city      import_date    
  admin       C:\         admin         toronto   04/12/2012
  </code></pre>
  
  <h1>Error:</h1>
  
  <p>Msg 4863, Level 16, State 1, Line 1<br>
  Bulk load data conversion error (truncation) for row 1, column 6 (validated).<br>
  Msg 7399, Level 16, State 1, Line 1<br>
  The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
  Msg 7330, Level 16, State 2, Line 1<br>
  Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".</p>