Error DTS, dbf to SQL

[jshanoo]

Hi all,
sorry for posting this here, because less response in sql server forum.
-----------------------------------------------------
error at destination for rownumber 1 errors encountered so far in this task: 1. insert error, column 8('ent_date',DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid character value for cast specification.
-------------------------------------------------------

This is the typical error message i get when i am trying to import data from foxpro dbf to sql server.
can any one please tell me how to avoid this.

*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[nigelrivett]

It's probably due to the way it tries to convert the foxpro date. Could be something to do with dmy formatting or maybe just that the date is out of the sql server acceptable range.

I always try to do transfers into staging tables with charcter columns - then you can see what is wrong wit hthe data when a copy to the production table fails.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[jshanoo]

Hi,
#into staging tables #

how to do this?,
i ahve given the field as datetime and null
any other alternative



*** Even the Best, did the Bad and Made the Best ***

John Philip