Post reply

Empty date value from csv ends up as 1899-12-30 in sql table?

  • November 17, 2009 at 11:02 am

    #137277

    I'm using SSIS 2005 to load a flat file (tab delimited csv) to a sql table. For some reason, null (blank) date values in the csv end up as 1899-12-30 in the sql table where the field is defined as datetime; I'd like a null value to exist in the sql table.

    In the OLE DB Destination editor, I'm using "table or view - fast load" and "Keep Nulls" is checked.

    I'm not sure how to fix this.

    Suggestions?

    (thanks in advance)

    --Pete

  • November 17, 2009 at 11:20 am

    #1080417

    Never mind -- I discovered that the flat file source has a checkbox for "retain nulls" which I didn't notice at first. Null values are now coming through as null in the sql table, as expected.

    --pete

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

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