Oracle home not found

• hampsonpaul80

  SSC Enthusiast

  Points: 188

  More actions

  May 18, 2020 at 12:35 pm

  #3752482

  My SSIS package  is failing. I am trying to select data from an oracle database but I am receiving the "Oracle Home not found" error.I can connect to the oracle by creating an oracle source and can preview the data that the select query will bring in but there is a "Oracle Home not found" error when the package is executed. I have made sure that I only have the 32 bit drivers and have specified that the package be execute as a 32bit package but it still doesn't work. I am using SSIS in VS 2017 with an Oracle XE 18c database (cdm). I have tried everything.

   

  • This topic was modified 3 years, 11 months ago by  hampsonpaul80.
  • This topic was modified 3 years, 11 months ago by  hampsonpaul80.

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  May 19, 2020 at 1:10 pm

  #3752871

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.