title: Bulk insert error, when loading date format
body: <p>I'm receiving a lot of .csv files that I need to bulk insert into a SQL table.</p>
  
  <p>In the csv file the date format is in YYYY-MM-DD and a seperate column for time which is in format HH:MM:SS.</p>
  
  <pre><code>"2016-11-24";"01:00:16"
  </code></pre>
  
  <p>In my table I created the two columns as a date datatype and a time datatype and using this piece of code to insert:</p>
  
  <pre><code>BULK
  INSERT [dbo].[table_name]
  FROM 'filepath'
  WITH
  (
  FIRSTROW = 2,
  FIELDTERMINATOR = ';',
  ROWTERMINATOR = '\n'
  )
  </code></pre>
  
  <p>But I get this error:</p>
  
  <pre><code>Msg 4864, Level 16, State 1, Line 37
  Bulk load data conversion error (type mismatch or invalid character for the     specified codepage) for row 2, column 1 (date).
  </code></pre>
  
  <p>If I use a normal insert into statement it works...</p>