You posted another question, which included a longer sample of the data. From that I could tell that there were more datetime values in that file - but the other fields had a different format than the two above in the screenshot. Since DATE_FORMAT is on table level, it seems that you lose here.
And in any case, the data source may be trusted to always have dates in the same format, or have correct dates.
I would recommend that you have the columns as varchar in the table. Then create a view on the top of table, where you do a try_convert
to datetime2(0)
with the appropriate format codes. (You find these these in the topic for CAST and CONVERT in Books Online.) You may also want to expose a raw character column in that view, so that you can easily analyse dates that do not convert.