{"id":4145,"date":"2021-05-25T05:34:46","date_gmt":"2021-05-25T05:34:46","guid":{"rendered":"https:\/\/himbap.com\/blog\/?p=4145"},"modified":"2021-05-25T05:34:46","modified_gmt":"2021-05-25T05:34:46","slug":"fixing-the-runtime-connection-manager-with-the-id-cannot-be-found","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=4145","title":{"rendered":"Fixing – The runtime connection manager with the ID cannot be found"},"content":{"rendered":"

Issue<\/strong>
\nRecently\u00a0I was working on scheduling SSIS packages developed using Kingswaysoft toolkit for Dynamics 365 CRM, while testing my job I encountered following error:<\/p>\n

“Source: Data Flow Task Dynamics CRM Destination [11]\u00a0 Description: The runtime\u00a0 connection manager with the ID\u00a0“{…}”\u00a0cannot be found. Verify that the connection\u00a0manager collection has a connection manager\u00a0\u00a0with that ID..”<\/strong><\/p>\n

Solution<\/strong>
\nBased on the error message, it seems while running it’s not able to connect or find the connection manager which is used to setup connection with Dynamics 365 CE organization. As I have copied this project from different machine, I thought there may be some issue in the connection manager so I recreated connection with Dynamics 365 CE but that did not helped.<\/p>\n

I tried to search if someone else having the same issue but I did not get much help, finally after troubleshooting I thought of reaching KingswaySoft Team and they are very good in providing support. Finally we solved this issue with the help of their support team. Let’s see what was the reason for this issue.<\/p>\n

While creating SSIS packages, we can setup connection individually for the SSIS package like below
\n\"ssis1\"<\/a><\/p>\n

Or can create shared connection manager under Connection Managers like below
\n\"ssis2\"<\/a><\/p>\n

Now depending on which option you selected you need to select scheduling options for your SSIS packages. If you are using shared connection manager then you need to deploy your complete project to integration service catalog and while scheduling your packages you need to select from your catalog<\/p>\n

\"ssis3\"<\/a><\/p>\n

And if you have used individual connection manager for your SSIS packages then you need to select file system and need to select SSIS packages location like below<\/p>\n

\"ssis4\"<\/a><\/p>\n

In my case I was using shared connection manager but I was trying to deploy individual SSIS package using file system and got this error.<\/p>\n

Summary<\/strong>
\nWe learned how depending on you have used connection manager, we need to deploy and schedule packages.<\/p>\n

Hope it will help someone!
\nKeep learning, Keep sharing !!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Issue Recently\u00a0I was working on scheduling SSIS packages developed using Kingswaysoft toolkit for Dynamics 365 CRM, while testing my job I encountered following error: “Source: Data Flow Task Dynamics CRM Destination [11]\u00a0 Description: The runtime\u00a0 connection manager with the ID\u00a0“{…}”\u00a0cannot be found. Verify that the connection\u00a0manager collection has a connection manager\u00a0\u00a0with that ID..” Solution Based on the error message, it… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[847,402,522,882,883],"tags":[884,885],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4145"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4145"}],"version-history":[{"count":2,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4145\/revisions"}],"predecessor-version":[{"id":4151,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4145\/revisions\/4151"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}