Reg: SSH Connection manager error when try to run the package in different server using sql agent job

[Tusen]

Hi Ivan,

I am Thiru from CSC chennai.

I am using SFTP task in my project and i have developed two
packages using your SFTP task.

Working fine in BIDS and Package Utility and Agent job in my DEV
server.

When i try to run the package through BIDS and Package Utility it
is running fine but it it not running through SqlAgent job in QA
server.


I copied the .dll in TASK, Connection, Assembly folders.

Server Configuration is:

64bit processor, 16GB RAM

i am getting the error which i noticed below.

Error: 2008-04-23 05:33:57.23
Code: 0xC0014005
Source:
Description: The connection type "SSH" specified for connection
manager "SFTP
-CON" is not recognized as a valid connection manager type. This error
is return
ed when an attempt is made to create a connection manager for an
unknown connect
ion type. Check the spelling in the connection type name.

End Error
Error: 2008-04-23 05:33:57.26
Code: 0xC0010018
Source:
Description: Error loading value "<DTS:ConnectionManager
xmlns:DTS="www.micro
soft.com/SqlServer/Dts"><DTS:Property DTS:Name="DelayValidation">0</
DTS:Property
><DTS:Property DTS:Name="ObjectName">SFTP-CON</DTS:Property><DTS:Property DTS:Na
me="DTSID">{49D115FA-B208-4BFC-928D-7CC0964E743A}</DT" from node
"DTS:Connection
Manager".

End Error
Error: 2008-04-23 05:33:57.29
Code: 0xC00220DE
Source: EPT Calling SFTP_Inbound
Description: Error 0xC0010014 while loading package file "C:\ETL
Packages\SFTPInbound.dtsx". One or more error
occurred. There should be more specific errors preceding this one that
explains
the details of the errors. This message is used as a return value from
functions
that encounter errors.

[Ivan Peev]

Thiru,

Please check our FAQ at http://www.cozyroc.com/content/faq

Check the solution under: "Why do I get the following error when
executing a package under Win64?"

Regards,
Ivan