Results 1 to 2 of 2

Thread: Error converting oracle date field to sql

  1. Sep 12th, 2006, 03:17 AM #1
    davebat
    davebat is offline

    Thread Starter
    Fanatic Member davebat's Avatar
    Join Date
    Dec 2002
    Posts
    727

    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
    Reply With Quote Reply With Quote
  2. Sep 12th, 2006, 05:03 AM #2
    jp140768
    jp140768 is offline
    Addicted Member
    Join Date
    Oct 2004
    Location
    Clane, Ireland
    Posts
    179

    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.
    JP

    Please rate the postings
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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