by Paul Kohler
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".
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.
Subscribe