hi,

i ran into same issue. I spent sometime trying to understand and fix it by redesigning tables and other ways, but to no avail.

So I included a Execute SQL Task in my SSIS which updates the table, updates all the records with '1753-01-01 00:00:00.000' to NULL.

I know this is quite a while ago, hope this helps people in the future.