SSH Connection Manager problem
Yarfitz, Stu
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
Yarfitz, Stu
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
Ivan Peev
Have you checked our FAQ article over here: http://www.cozyroc.com/support/ssis_faq.html
?
Search for "SQL Server Agent Job". You may have to change the
encryption type you use for your SSIS package because the default one
doesn't work at all. There is also a material here:
http://www.cubido.at/Blog/tabid/176/EntryID/155/Default.aspx
which describes in details what is wrong with the default encryption.
Let me know if you are still having problems.
Regards,
Ivan