title: BULK INSERT in SQL SERVER Truncation Error
body: <p>While trying to bulk insert an excel file into a table, I am getting the following error</p>
  
  <blockquote>
    <p>42000 - [SQL Server]Bulk load data conversion error (truncation) for row 2, column 5 (service_center).</p>
  </blockquote>
  
  <p>The tab delimited file looks something like this</p>
  
  <pre><code>protocol    address  date   type    body    service_center  read_status status  date_sent   readable_date   contact_name
  0   AM-GIBSBS   " 14,98,31,75,95,113 "  1   "Apply for MBA in 3rd Best B-School, Residential Campus, 100% Placement, Education Loan Asst., Avail Scholarship - Missed Call 08030072318 / www.gibsbschool.com"   +919892081135   1   -1  1.49832E+12 "Jun 24, 2017 20:49:55" (Unknown)
  </code></pre>
  
  <p>My bulk insert and create table code looks something like this</p>
  
  <pre><code>CREATE TABLE sms_tbl (
      protocol VARCHAR(50),
      address VARCHAR(50),
      type VARCHAR(50),
      body VARCHAR(500),
      service_center VARCHAR(50),
      read_status VARCHAR(50),
      status VARCHAR(50),
      date_sent VARCHAR(50),
      readable_date VARCHAR(50),
      contact_name VARCHAR(50))
  
  
  BULK INSERT sms_tbl
      FROM 'C:\Users\BIKASH-pc\SmsCallContact\SMS_Bikash.txt'
          WITH ( FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n',FIRSTROW=2)
  </code></pre>
  
  <p>Upon changing the body column to the beginning as the 1st column, the code seems to be working fine. I am not able to find out the reason why this error is taking place.</p>