title: Why am I getting Bulk load data conversion error (truncation) for row 1, column 56 (File_upload)?
body: <p>I am facing the problem when I am loading data in SQL server using bulk<br>
       loader(SQL loader).Here I am generating my file through java code and at<br>
       the end of the line I write line terminator.</p>
  
  <pre><code>my code is -
  
  
    BULK INSERT ExcelFile
     FROM 'D:\201606162171840OwnersImportFormat.csv'
       WITH
        (
       -- FIRSTROW = 2,
        FIELDTERMINATOR = ',',  --CSV field delimiter
       ROWTERMINATOR = '\n'  ,
       FirstRow = 1 --Use to shift the control to next row
      -- ERRORFILE = 'D:\SchoolsErrorRows.csv',
     --  TABLOCK
  );
  
  I am getting the error like Bulk load data conversion error (truncation) for  
  row 1, column 56 (File_upload).
  Please tell me where I am going wrong.
  </code></pre>
  
  <p><a href="http://i.stack.imgur.com/fiGom.png" rel="nofollow">Click here to see file data and table structure</a></p>