20. January 2010 18:55
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".
- 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.