we have a flat text file that has blanks in some of the date columns.
when we use open xml to import data to a table, the blank date values get loaded as 1900-01-01. why does this happen? Is there any way to get these blanks loaded as NULLs to the table.
The blanks are being interpreted as zeros somewhere along the way. In sql server, the zero-date is 1900-01-01. I'd have to see all the steps of your process to determine where this is occuring, but you could probably just update all the 1900-01-01 values to null in your table at the end or your process.
If it's not practically useful, then it's practically useless.