title: Bulk Load with commas in columns causing truncation errors
body: <p>I am trying to bulk import a <code>.CSV</code> file with 13 columns into SQL Server using Management Studio 2014 with the following script and am encountering truncation issues:</p>
  
  <pre><code>CREATE TABLE #BudgetPlan 
  (
       BUSINESS_UNIT VARCHAR(50), 
       DEPT VARCHAR(50), 
       JOBCODE VARCHAR(50), 
       FISCAL_YEAR VARCHAR(4), 
       FISCAL_MN VARCHAR(3),
       REG_HOURS DECIMAL(10, 2), 
       OT_HOURS DECIMAL(10, 2), 
       CONTRACT_HOURS DECIMAL(10, 2), 
       NON_PROD_HOURS DECIMAL(10, 2), 
       REG_SAL DECIMAL(10, 2), 
       OT_SAL DECIMAL(10, 2), 
       CONTRACT_DOL DECIMAL(10, 2), 
       NONPROD_SAL DECIMAL(10, 2)
  )
  
  BULK INSERT #BudgetPlan 
  FROM '\\nt115\TESTING\Consolidated Hours Dollars.csv' 
  WITH ( FIELDTERMINATOR = ',')
  </code></pre>
  
  <p>I get some errors:</p>
  
  <blockquote>
    <p>Msg 4863, Level 16, State 1, Line 49<br>
    Bulk load data conversion error (truncation) for row 1, column 4 (FISCAL_YEAR).</p>
    
    <p>Msg 4863, Level 16, State 1, Line 49<br>
    Bulk load data conversion error (truncation) for row 2, column 4 (FISCAL_YEAR).</p>
  </blockquote>
  
  <p>Column 3 (<code>JOBCODE</code>) does have some commas within the string, however where there are rows with commas in this column they are surrounded by double quotes (") but I think is still causing an issue. Rows 1 and 2 below have commas within the column and are surrounded by double quotes, however row 3 does not have a comma within the JOBCODE column, and therefore does not contain double quotes.</p>
  
  <p>Here is a sample of the CSV input file:</p>
  
  <pre><code>11000 - General Hospital,600 - Nursing Admin,"1018 - VP, Nursing Services",FY20,Jul,157,0,0,27,14045,0,0,2440
  11000 - General Hospital,600 - Nursing Admin,"1018 - VP, Nursing Services",FY20,Aug,159,0,0,17,14223,0,0,1545
  11000 - General Hospital,600 - Nursing Admin,3029 - Clinical Nurse Educator,FY20,May,0,0,0,0,0,0,0,0
  </code></pre>
  
  <p>Any help is appreciated, thanks!</p>