Hello again, I just tried running the package that works when run
directly from SSIS as part of a SQL Agent job.  The job fails to run.  I
have been having this trouble when running packages that include tasks
that run sftp .bat file executables, and was hoping that CozyRoc would
solve this problem.  -Stu

________________________________

From: cozyroc@googlegroups.com [mailto:cozyroc@googlegroups.com] On
Behalf Of Yarfitz, Stu
Sent: Monday, March 24, 2008 2:16 PM
To: cozyroc@googlegroups.com
Subject: SSH Connection Manager problem

Hello, I downloaded CozyRoc SSIS+ 1.2 today to determine whether it
would meet my needs for running sftp tasks in SSIS packages under SQL
Server Agent scheduler control.  I was able to easily connect up to one
computer running ssh, and the sftp file transfer worked perfectly.  I
was unsuccessful however connecting with a second server that is also
currently functioning as an sftp host.  

Here is the error message I received while trying to configure the SSH
Connection Manager server settings.

===================================

Auth fail (Tamir.SharpSSH)

------------------------------

Program Location:

   at Tamir.SharpSsh.jsch.Session.connect(Int32 connectTimeout)

   at CozyRoc.SqlServer.SSIS.SshClientConnection.Connect(String
channelType)

   at
CozyRoc.SqlServer.SSIS.SshConnectionManagerForm.btnTestConnection_Click(
Object sender, EventArgs e)

What could be causing this behavior.? Thanks.

Stu Yarfitz

Systems Analyst/Programmer

Collaborative Data Services

Fred Hutchinson Cancer Research Center

206-667-4247

syarf...@fhcrc.org