We are importing a foxpro table of 26 million records (includes datetime field, numeric field (13,5), and some VarChar types as well... into a SQL Server database using a DTS package.

The results yield close to 1000 records with either the datetime or numeric fields containing errors.

example :

ERROR AT DESTINATION FOR ROW NUMBER X. ERRORS ENCOUTNERED SO FAR IN THIS TASK : 893. INSERT ERROR, COLUMN 4 ('var', DBTYPE_NUMERIC), STATUS 12: INVALID STATUS FOR BOUND DATA. UNSPECIFIED ERROR.

INSERT ERROR, COLUMN 6('datetime', DBTYPE_DBTIMESTAMP), STATUS 6: DATA OVERFLOW. INVALID CHARACTER VALUE FOR CAST SPECIFICATION.

Can anyone explain what is going on, or tell us how to further limit these errors? The source data looks fine.

Thanks much