CozyRoc SFTP Task not connecting

307 views
Skip to first unread message

melanie...@gmail.com

unread,
Feb 25, 2016, 8:41:38 AM2/25/16
to COZYROC

I'm creating an SSIS package in Visual Studio 2012 using CozyRoc's SFTP Task. When I run the task, I get the following in the Output Window:





Error: 0xC002F304 at SFTP Task 1, SFTP Task: An error occurred with the following error message: "No such host is known".

When I click on Test Connection in my SSH Connection Manager, I get:

"The requested name is valid, but no data of the requested type was found (Rebex.Networking)"

I am able to connect to my FTP server using WinSCP, so I know the problem isn't the server.  Here's what I have in my SSH Connection Manager Server tab:

Host: sftp://<myserver>.com       Port:22
Username: <myusername>
Password: <mypassword>
Key File: <left blank>
Passphrase: <left blank>

I haven't touched the Advanced or Proxy tabs.

As for my SFTP Task, here's what I have:

StopOnFailure: True
Action: Receive files
Local: Downloaded File Manager (a File Connection Manager I created)
OverwriteLocal: True
FtpConnection: FTP Server (my SSH Connection Manager, see above)
Remote: /Export/HRExport/archive
IncludeSubFolders: False
RemoteFilter: <left blank>

Any idea what my problem is?  Thanks!!

Ivan Peev

unread,
Feb 25, 2016, 8:46:12 AM2/25/16
to COZYROC
Hi,

Specify your server host parameter without sftp:// in front. Try now to connect. Did it work?

melanie...@gmail.com

unread,
Feb 25, 2016, 3:06:24 PM2/25/16
to COZYROC
No, that doesn't help. With or without sftp:// I get the same error message.

Ivan Peev

unread,
Feb 25, 2016, 3:12:07 PM2/25/16
to COZYROC
Check again the error message. It should be different.

melanie...@gmail.com

unread,
Feb 26, 2016, 3:13:24 PM2/26/16
to COZYROC
No, the error message is exactly the same.

melanie...@gmail.com

unread,
Mar 2, 2016, 3:58:21 PM3/2/16
to COZYROC
My fault. I had a forward slash at the end of my connection string. Once that was removed, it works fine.
Reply all
Reply to author
Forward
0 new messages