March 5, 2024 at 9:06 pm
I've created a simple project with one dtsx that has 1 package connection which is a DynamicsCRM Type (Kingswaysoft).
So when I come to deploy to the SSISDB catalog it is successful.
Then I convert the connection to project and now when I deploy it fails on the 4th/last step with an error of
Failed to deploy the project. Fix the problems and try again later.:Unable to create the type with the name 'DynamicsCRM'.
This name DynamicsCRM is known as ServiceName in the properties of this connection.
Any ideas on what the issue maybe?
The SSIS solution has been configured the same way as other solutions, e.g.
Visual Studio 2019
Project Security ProtectionLevel = EncryptSensitiveWithUserKey
TargetServerVersion = SQL Server 2019
SQL Sever version 14.0.1000.169
March 5, 2024 at 9:34 pm
and did you bother googling for it or even asking the vendor? just searching for the error message gave me lots of hits including the solution.
March 6, 2024 at 12:00 pm
I have spent a few days researching on the internet with no great success. Also recreated a new solution as well just in case it got corrupted.
The only potential solution was to ensure the server has a kingswaysoft server license, which I do have now, but problem still exists.
Would you mind sharing what the solution could be?
March 6, 2024 at 3:52 pm
The solutions on the internet talk mostly about a reinstallation of the kingswaysoftware. Have you contacted the vendor yet?
And encrypt sensitive information (like you did with user key). Try it with password
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply