Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

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?

License

like image 755
Tim Hutchison Avatar asked Jun 20 '17 21:06

Tim Hutchison


1 Answers

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

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

like image 140
KingswaySoft Avatar answered Sep 30 '22 13:09

KingswaySoft