Error converting oracle date field to sql
I have a dts package that converts an oracle database to an sql table, it has been working but as of this week it has stopped with the error.
'Insert error, cloumn 5('startdate',DBTYPE_DBTIMESTAMP), Status 6: Data Overflow. Invalid character value for cast specification.
I am tryign to convert it to a datetime field and the source value looks like this
1988-06-15 00:00:00,
It also seems to fail at the 16000 record, is it possibly one corrupt record or will this be the maximum number of errors permitted. I dont have oracle so cant open the source table
Re: Error converting oracle date field to sql
Could you access the Oracle database via an ODBC driver, and query it with something like MSQRY, or create a linked table in Access?
This way you may be able to find the difference between this date and all the other ones.