Status 6 Data Overflow

[apcapc]

I am in the process of importing my Visual FoxPro database to SQL server for the first time, most of my tables have imported fine but I get the below area when importing my largest table

The number of failing rows exceeds the maximum specified
Insert Error, column 34('delivery',DBTYPE_DBTIMESTAMP),STATUS 6ata Overflow
Insert Error, column 35
('expiry',DBTYPE_DBTIMESTAMP),STATUS 6ata Overflow
Insert Error, column 38('commdate',DBTYPE_DBTIMESTAMP),STATUS 6ata Overflow
Invalid Character value for cast specification
Invalid Character value for cast specification
Invalid Character value for cast specification

Any advice on what this actually mean would be much appreciated

 

[zhavic]

What are the types of columns 'delivery', 'expiry' and 'commdate' in Visual FoxPro database ?

Zhavic

---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.

 

[apcapc]

They are all date fields

Andy

 

[zhavic]

try to look there, the same problem thread1252-813832

Zhavic

---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.