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

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  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

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  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