I am using visual-studio-2015 to create an ssis package targeted at sql-server-2012. I am using KingswaySoft to connect to dynamics-crm to read & update some data. My package runs correctly when I run it from Visual Studio. However, when I deploy the package to my server, the package no longer runs successfully. I am receiving multiple errors with the first error being:
The connection type "DynamicsCRM" specified for connection manager "Dynamics CRM Connection Manager" is not recognized a valid connection manager type.
Why am I receiving this error and why is it only showing up when the package has been deployed?
I have tried restarting the Integration Services on the server.
I checked the license on the server and I noticed that although I have the Ultimate Edition of KingswaySoft, one of the License Manager's doesn't have a license and won't accept my license key. Perhaps it's a licensing issue?
The error message indicates that you do not have our software installed on your integration server.
Edit: Re-installation solved the issue (per comments)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With