Can you explain what is this time: 12:00:00:00.000000AM
12 > hours 00 > minutes 00 > seconds 00.000000 > What is this part?!?
Your time has 4 parts instead of three. Are you sure that the time is not something like: 12:00:00.000000AM ?
If the time is like I posted above then you can use CONVERT to DATETIME2 using style 9
declare @txt NVARCHAR(100) SET @txt = 'Jan 03 2019 12:00:00.000000AM' SELECT CONVERT (DATETIME2, @txt, 9)
In this case, you can import the data into a staging table and then migrate the data to the original table using CONVERT as explained above
Another option is to use select from OPENROWSET and use CONVERT on the fly