Import date into SQL Server table

Question

I am importing this .csv and I would like to import the column Date as a date, not as a string:

Which data type should I choose: date or database date?

enter image description here

After importing it, will SQL Server be able to recognize it as a date?

score 3 · Answer 1 · edited May 23 '17 at 12:17

You can choose DT_DATE or DT_DBTIMESTAMP Data Type, both works.

Follow my answer at SSIS Source Format Implicit Conversion for Datetime it is very useful to you to know if this date format can be readed as Date value or need to be converted via a script component or else...

And you can Read more about IntergrationServices Data Types in these articles:

Import date into SQL Server table

1 Answers1