Bulk insert error, when loading date format
<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>