Information générale
Catégorie:
Bases de données
Titre:
Errors importing FOXPRO tables into SQLSERVER2003
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement