Post reply

Null dates change to 1/1/1753

  • December 12, 2013 at 11:12 am

    #281202

    Hello,

    I am using the SSMS export wizard to extract a table to a delimited flat file. The source table has some nullable datetime columns. When a row contains the null value for a date, the wizard changes it to the earliest possible date - 1/1/1753. I am trying to figure out how to keep the null value.

    I have read to

    1. Check "Retain Null values from source as null values in data flow"

    2. Check "Keep Nulls" in destination

    but those are not options in the export wizard. Is there a way to do this simple extract without using SSIS?

    thanks

  • December 12, 2013 at 12:29 pm

    #1673065

    I did go ahead and try this with SSIS. I think I realized the answer to my problem. There is no such thing as the null value in a flat file so SQL uses the minimum date instead.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply