Hello,

I created a DTS to upload data from Visual FoxPro 7 to SQL Server 2000. Two fields are creating an error during the upload; one is N(14,4), the other is N(4,0). On the SQL Server side, they are data type float. I get this error message when I execute the DTS:

TransformCopy 'DirectCopyXForm' conversion error: Conversion invalid for datatypes on column_pair3 (source column 'fiscal_year' (DBTYPE_NUMERIC), destination column 'fiscal_year' (DBTYPE_R8)).

What should I do?

Thanks,
Joe Koontz