2 Replies Latest reply: Jan 27, 2012 1:53 AM by 913164 RSS

    Import from Oracle DB using SSIS is failing

    913164
      We are able to connect to Oracle (10g) DB using 64 bit Oracle 11g Client and successfully execute the SSIS package using BIDS. But if we try to execute the same through code which is using a DTSEXEC utility to execute the package we are getting an ‘Execute Failure’ status.

      Could you please advise what could be wrong?
        • 1. Re: Import from Oracle DB using SSIS is failing
          orafad
          The component you are calling may not be 64-bit (and I believe DTS exist as both 32 and 64-bit executable). If it is 32-bit, thus needing 32-bit libraries, it may explain "execute failure".
          • 2. Re: Import from Oracle DB using SSIS is failing
            913164
            I tried the suggestion provided by you. It gives an error while connection establishment. If I use the 64 bit DTexec utility to execute the same package it connects but throws an internal data conversion error. I even tried to run the package through Execute package utility in SQL Server it is also not working. The same package runs perfectly fine in the development server having 32 bit Oracle Client.

            Please advise.