Was getting 30 December 1899 on a SSIS flat file import

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:

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.

August 30. 14:45
I thought we were developing an enterprise application, judging by the docs we need to produce apparently it’s a rocket. #it #dev

August 25. 23:38
Done. Production deploy tomorrow, then feet up :-P

August 22. 14:56
I am trying to pipe all my work to /dev/null for a bit and just hope that no one notices (is that so bad?!) :-P

June 30. 22:26
And then the developer said, "but it works on my machine!" :-P

May 12. 23:48
Inspired about AOP and LinFu after listening to hanselminutes: http://www.hanselminutes.com/ #aop #linfu

follow my tweets...