>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.

Make sure that you don't have values in the 'sqty' field that does not fit into N(15,6)