Hi,

I am trying to import a table from Oracle 8i database using Oracle Provider
for OLEDB and encountered the following error:

Error at Destination for Row number 38142. Errors encountered so far in
this task: 1. Insert error, column 40 ('DUE_DATE', DBTYPE_DBTIMESTAMP),
status 6: Data overflow.
Insert error, column 25 ('RCVD_DATE', DBTYPE_DBTIMESTAMP), status 6: Data
overflow.
Invalid character value for cast specification.
Invalid character value for cast specification.

The 'DUE_DATE' and 'RCVD_DATE' columns are 'datetime'.

Thanks in advance.

Thank you,

Sang
MS Sql Server LazyDBA home page