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

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

Ivan Peev

View profile

More options Apr 24, 7:09 am

From: Ivan Peev <ivan.p...@cozyroc.com>

Date: Thu, 24 Apr 2008 04:09:46 -0700 (PDT)

Local: Thurs, Apr 24 2008 7:09 am

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

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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

On Apr 23, 8:56 am, Tusen <psenthilkumar....@gmail.com> wrote:

> 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.

Reply to author Forward