Also, you should see an option bit in file source connection in the data flow to retain NULLs ... this will retain the NULL "value" from your file and not assign those arbitrary/bogus dates. (this also lets you not have to monkey with the date field in a derived column task to NULL-out that field in the data flow, as mentioned above - either way should work, though)