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