|
-
Sep 12th, 2006, 03:17 AM
#1
Thread Starter
Fanatic Member
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|