Resolve SSIS Package with Kingswaysoft error: Connection type “DynamicsCRM” is not recognized as a valid connection manager type

5
votes

I am using to create an package targeted at . I am using KingswaySoft to connect to 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?

License

1
sql-servervisual-studiossisdynamics-crmkingswaysoft
did you buy the license for KingswaySoft? – Guido Preite
@GuidoPreite Yes - I also confirmed that the license is active on the server – Tim Hutchison
then contact KingswaySoft support – Guido Preite

1 Answers

4
votes

The error message indicates that you do not have our software installed on your integration server.

Edit: Re-installation solved the issue (per comments)