>I'm using the DTC services on SqlServer 7.0 to import a DBF. The DBF has 16,000 rows and 75 fields. The error log tells me which row caused the error, but not which field. With 75 fields, that's relevant. If there a way to determine which field is causing the error? The error message is "Invalid character value for cast specification".
>
>TIA
>Bill
I don't know how much help this is going to be but I do know that DTS (and BCP) don't handle VFP's empty dates.
-Mike