Why do I get the following error when executing a package under Win64?
Error: 0xC0014005 at : The connection type "SSH" specified for connection manager "SSH Connection Manager 1" 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.
Starting from SSIS+ 1.3 SR-2, this error is resolved. Use the 64bit installation.
By default SSIS+ is installed under the 32bit - Program Files (x86) folder. You have two options:
- Set Run64BitRuntime project property to False to force SSIS to execute with the 32bit runtime.
- or ... find CozyRoc.SSISPlus.dll library and manually copy it to the following 64bit folders:
- Microsoft SQL Server\90\DTS\Connections
- Microsoft SQL Server\90\DTS\Tasks
- Microsoft SQL Server\90\DTS\PipelineComponents
- Microsoft SQL Server\90\SDK\Assemblies
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+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
I want to use DSA keys with my SFTP server and I have generated a public-private keys pair with PuttyGen. When I test connection, I get an error *Auth Fail"
PuttyGen doesn't generate proper DSA keys, which can work with the SSH Connection Manager. You may use ssh-keygen application, which generates keys recognized by SSH Connection Manager. The application is part of the OpenSSH package. Use the ...Error Message: SSH: Negotiation failed. The client and the server have no common encryption algorithm.
Action: When I use SSH Connection Manager to transfer files, I get the following error message. Error Message: SshSession(8)[1]:SSH: Negotiation failed. The client and the server have no common encryption algorithm. Solution: This error message ...I get "invalid server's version String" error, when trying to connect SFTP server.
You may have firewall/proxy issue. Make sure you can successfully telnet your server. You should get back text starting with "SSH-2.0".Error Message: An error occurred with the following error message: Response reading timed out.
Action: When executing a command using the SSH Execute Task the following error message is received. Error Message: An error occurred with the following error message: Response reading timed out. Solution: Increase the timeout parameter in the SSH ...How to script and modify the variables of Package connection
To iterate and modify the variables used by a package, follow these steps: Create a script task. Reference CozyRoc.SSISPlus library. In the script get reference to a package connection manager. Get connection manager InnerObject property and cast it ...