Hello all ,
When testing the package from vs everything goes as expected and the task finishes without any errors . However , when I publish the package to SSISDB on Sql Server the package fails with this error
- KingswaySoft.IntegrationToolkit.DynamicsCrm.CrmServiceException : CRM service call returned an error : A password is required in order to establish the connection ...
When Im using Integrated Security i get the same error just that the user cannot be authenticated !
I'm using KingswaySoft as a tool for integration . I have package sensitivity as EncryptSensitiveWithUserKey and I'm writing the password on the connection manager .
Everything is ok on testing but when published it fails !
*This post is locked for comments