title: SQL Server Bulk Insert Failure
body: <p>Consider the table: </p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE [dbo].[inputdata](
      [Name] [varchar](150) NULL,
      [AddressStreet] [varchar](150) NULL,
      [AddressStreet2] [varchar](150) NULL,
      [City] [varchar](150) NULL,
      [State] [varchar](2) NULL,
      [Zip] [varchar](5) NULL,
      [Phone] [varchar](10) NULL,
      [Campus] [varchar](50) NULL,
      [Access] [varchar](50) NULL,
      [Type] [varchar](50) NULL,
      [Degree] [varchar](50) NULL,
      [Unknown1] [varchar](50) NULL,
      [Unknown2] [varchar](50) NULL,
      [IdentType] [varchar](50) NULL,
      [Unknown3] [varchar](50) NULL
  ) ON [PRIMARY]
  
  GO
  
  SET ANSI_PADDING OFF
  GO
  </code></pre>
  
  <p>And the insert script:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SET ANSI_DEFAULTS ON
  
  BULK INSERT dbo.inputdata
  FROM 'C:\inputdata.csv'
  WITH (
     FIELDTERMINATOR = ','
     ,ROWTERMINATOR='\n' 
  )
  </code></pre>
  
  <p>Why is the following error output: </p>
  
  <blockquote>
    <p>The bulk load failed. The column is too long in the data file for row 1, column 15. Verify that the field terminator and row terminator are specified correctly.</p>
  </blockquote>
  
  <p>DataRow 1 (I manually added the \n for this question, the character exists in each row from the file): </p>
  
  <pre><code>1CRESCENT CITY BARTENDING INSTITUTE,209 N. BROAD AVE., ,NEW ORLEANS,LA,70119,.,Regular,Private,1-2 years,Diploma, , ,IPEDSUNIT,158617,\n
  </code></pre>