Getting (datetime2) or (date) data types while importing data from csv file to SQL Server using the-CodePudding

My issue: getting datetime2 or date datatypes while importing data from a .csv file into SQL Server using the import wizard.

Problem detail: in the .csv file I have an entrydate value, when I import the data from the csv, using SQL Server import wizard and setting the datatype to either DateTime2 or Date, then the import fails because it doesn't understand these two datatypes.

I have to manually change to datetime to get around this error:

Screenshot of the issue Screenshot of the error message Thanks for helping :-)

CodePudding user response：

Those data types are not supported in Sql Server 2005, the version you are using based on the result of select @@version in the comments.