SQL Server Performance

ODBC ORACLE FAILURE

Discussion in 'SQL Server DTS-Related Questions' started by kempo, Nov 10, 2003.

  1. kempo New Member

    I have a DTS with the Source being ORACLE and the Destination being SQL. When I schedule the package it fails with the following error,
    "HResult of 0x80004005(-2147467259) returned. Unexpected error occured. An error result was returned without an error message".

    When I run the package manually I have to double click the ODBC connection a few times and clcik OK to accept the error message and after a few times I can connect and then execute the package. Any suggestions?
  2. satya Moderator

    Ensure you're using correct driver and oracle client tools are installed on SQL server.
    BTW what is the level of service pack on SQL & OS?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. kempo New Member

    I do have the correct Oracle driver and my OS SP is 4 and I have no SQL SP so that could be the problem. I'll install the SQL SP and see what happens. Watch this space.
  4. satya Moderator

    Yes you must have latest service pack to deal with such issues in LS/DTS objects.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  5. kempo New Member

    Hi,<br /><br />Juts to complete this topic, I installed all the lates service packs and have run 1 weeks worth of data loads from Oracle without any failures.<br /><br />Thanks<br /><br />[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]

Share This Page