Issue
Recently I was working on scheduling SSIS packages developed using Kingswaysoft toolkit for Dynamics 365 CRM, while testing my job I encountered the following error,
“Source - Data Flow Task Dynamics CRM Destination [11]
Description - The runtime connection manager with the ID “{…}” cannot be found. Verify that the connection manager collection has a connection manager with that ID..”
Solution
Based on the error message, it seems while running it’s not able to connect or find the connection manager which is used to setup a connection with Dynamics 365 CE organization. As I have copied this project from a different machine, I thought there may be some issue in the connection manager so I recreated the connection with Dynamics 365 CE but that did not help.
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 at providing support. Finally, we solved this issue with the help of their support team. Let’s see what was the reason for this issue.
While creating SSIS packages, we can setup connection individually for the SSIS package like below,
Or can create a shared connection manager under Connection Managers like below,
Now depending on which option you selected you to need to select scheduling options for your SSIS packages. If you are using a shared connection manager then you need to deploy your complete project to the integration service catalog and while scheduling your packages you need to select from your catalog.
And if you have used individual connection manager for your SSIS packages then you need to select the file system and need to select SSIS packages location like below,
In my case, I was using a shared connection manager but I was trying to deploy an individual SSIS package using a file system and got this error.
Summary
We learned how depending on you have used connection manager, we need to deploy and schedule packages.
Hope it will help someone!
Keep learning, Keep sharing !!