question

smitak-2532 avatar image
0 Votes"
smitak-2532 asked Zoehui-MSFT answered

SSIS works in Visual Studio but not on integration catalog.

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered

Hi @smitak-2532,

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.