I used SSIS to create a Table and import data into the database. A couple of columns are DateTime field and the values are blank for some. I noticed that the result was that the following value “1753-01-01 00:00:00.000 ” was placed in the fields. I tried using the SQL Update command and that made no difference. Here is the solution
- Open the SSIS package file with Notepad.
- Search for “Retainnulls“. Set it to true.
Run the Update command like this
set startdate = cast(‘2017-01-30 00:00:00.000’ as datetime)
where Employeeid = ‘5551212’