SSIS Oracle Source - DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

  • Hi All,

    I'm using Visual Studio 2019 to get data from a Oracle Database and transfer it to a SQL 2019 database. I'm using Oracle connection (Connection Manager for Oracle Connections) for my source and an OLE DB connection for my SQL 2019 database. Test connection work fine for both and when I execute the package in VS2019, it works fine.

    When I deploy it to SQL2019 and run it from a agent job, I get a DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER error. I have seen some forums and done following changes,

    In VS2019 Run64BitRuntime to false

    In agent job, checked it to run in 32bit mode.

    Installed MicrosoftSSISOracleConnector on the server containing SQL2019

    Tired by setting DTS property to EncryptSensitiveWithUserKey and with password too.

    Also tried DelayValidation with True and with False.

    But no joy so far. Has anyone troubleshooted this in past and can shed some light on this please?

     

     

     

    • This topic was modified 1 week, 5 days ago by  BIDeveloper.
  • Thanks for posting your issue and hopefully someone will answer soon.

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply