>>>>I'm trying to move data from a foxpro table up to sql server on just one table I get "Data for source column 12 ('sqty') is not available" I've pack the table and copied to another table and tried with the same error. In VFP the field is defined as N(15,6) and in SQL it's a decimal(15,6). Any ideas on how to solve this? No records get imported over.
>>>
>>>Just a SWAG, but have you tried bigger scale and precision on SQL Server side? Could it also be that some records in VFP table have **** in them?
>>
>>I check the *** and made sure none of the data in VFP was bigger then 99999999.999999
>
>Try bigger precisions and scale on SQL Server anyway.
Made it 20,8 and still same result.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers