SSIS works in Visual Studio but not on integration catalog.

smita k 1 Reputation point
2021-09-30T20:03:34.457+00:00

I have SSIS package on SSDT 2017 with Oracle connector. It works fine on target SQL 2017. When I deploy the ispac on integration catalog. I get the below error.

Cannot find the connection manager with ID "{818AC64C-1212-1212-A8A4-A112B1BAEFF0}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "o table1.Connections[MSOraConnection]" in the connection manager collection of "o table1". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.

The connection manager with that ID very much exists. I have TCP/IP enabled.
I have installed Oracle client 19c, oracle connector and Attunity 32 bit and 64 bit.

I have read countless forums in last two days, tried the mentioned solutions but no luck running the ispac on integration catalog.

Kindly help!

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,381 Reputation points
    2021-10-01T06:12:26.313+00:00

    Hi @smita k ,

    Do you mean that when you run the package in catalog it thrown the error?

    Please help check if you are using shared connection manager or not.

    If this does not work, you may follow this blog to do some troubleshooting.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments No comments