Import from Foxpro 2.6 to SQL2000 null date value populates

[abuchan]

While doing a data transformation from Foxpro 2.6 to SQL2000 it would seem that all date fields that are empty in the source populate in SQL as '1899-12-30'. Is there any way on the conversion task to keep this field empty?

 

[SQLSister]

I had a simliar problem and added an execute SQL task after the import (on success)to do the following:
UPDATE Airport
SET FacInfoDate = NULL
WHERE FacInfoDate = '1899-12-30'
GO

JUst change the column and table name and you've got it.