We are using the following command to create the text file for a SQL bulk insert:

Copy To < filename > Delimited With "" With Character "|"

We need to be able to propagate nulls for datetime into the SQL but these are being converted to empty datetimes in the text file.

We can change nulls to a bogus date like {12/31/9999 12:00:00 AM} and reconvert to null once the data is brought into SQL.

Is there a way to preserve the null values as part of the copy to?

TIA