>I have found that the best is to simply remove the database from SQL Server and simply create it before running the package again. Otherwise, the package cannot run if some data is part of the database.
>
>I also found that empty date values in VFP causes the package to stop importing the data as soon as found. So, other than to replace all empty values with the 1899 date value, would it there be a way to adjust the package so it would be smart enough and would know how to deal with it?

Yes, there is a way to deal if error rows. In the Output columns you can redirect rows instead of failure, to do data cleansing. You can add a derive transformation and or scripting transformation to do just about anything because these are row processing transformations.


Carl