title: Bulk load data conversion error (truncation)
body: <p>I am getting this error </p>
  
  <pre><code>Bulk load data conversion error (truncation) for row 1, column 12 (is_download)
  </code></pre>
  
  <p>here is the csv...it only has one row</p>
  
  <pre><code>30,Bill,Worthy,sales,,709888499,bat@bat.com,,"Im a a people person., to work together for this new emerging env.HTTP://applesoftware.com","Bill and Son of Co","Contact Us: Contact Form",0
  </code></pre>
  
  <p>here is my bulk insert statement...</p>
  
  <pre><code>SE SalesLogix
  GO
  
  CREATE TABLE CSVTemp
  (id INT,
  firstname VARCHAR(255),
  lastname VARCHAR(255),
  department VARCHAR(255),
  architecture VARCHAR(255),
  phone VARCHAR(255),
  email VARCHAR(255),
  download VARCHAR(255),
  comments VARCHAR(MAX),
  company VARCHAR(255),
  location VARCHAR(255),
  is_download VARCHAR(255)
  )
  GO
  
  BULK
  INSERT CSVTemp
  FROM 'c:\leads\leads.csv'
  WITH
  (
  DATAFILETYPE = 'char', 
  BATCHSIZE = 50, 
  FIELDTERMINATOR = ',', 
  ROWTERMINATOR = '\n' 
  )
  GO
  --Check the content of the table.
  SELECT *
  FROM CSVTemp
  GO
  </code></pre>
  
  <p>The problem is most of the time it works great but in some situations (this being one of them) I get the errors</p>
  
  <p>ANy ideas on what is causing this record to have this error</p>