The connection type xxxx specified for connection manager xxxx is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for

Error Message: The connection type "xxxx" specified for connection manager "xxxx" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

Action:

When I try to deploy my SSIS package from the SSISDB catalog, I get the following error:

Error Message:

The connection type "xxxx" specified for connection manager "xxxx" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

Solution:

In order to solve this issue, install the latest COZYROC SSIS+ library on the machine where the SSIS Catalog you are using is stored.


    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.