pk software dev blog

custom microsoft .net application development

20. January 2010 18:55
by Paul

Was getting 30 December 1899 on a SSIS flat file import

20. January 2010 18:55 by Paul

I had a simple SSIS flat file import going but the empty date fields were not showing up as null but "1899-12-30 00:00:00.000".

Short answer:
  • Right click "flat file source" component
  • Select "Show Advanced Editor" from the context menu
  • On the "Component Properties" tab set "RetainNulls" to true

I knew it was hidden somewhere! This post helped - http://phil-austin.blogspot.com/2007/12/retain-nulls.html - my issue was all the same except for the date value.