Topic "Host does not exist error in SSIS"

Author Message
Guest




I developed a script:

option batch on
option confirm off
open <session name>
cd <directory containing remote file>
get <remote file name> <local path>
exit

When I run open <session name> from the command window, it connects just fine. When I run the script in the Execute Process Task of SSIS, it prints:

Searching for host...
Host does not exist

Here is the excerpt from the log:

. 2010-08-12 17:54:56.459 --------------------------------------------------------------------------
. 2010-08-12 17:54:56.459 WinSCP Version 4.2.8 (Build 818) (OS 5.2.3790 Service Pack 2)
. 2010-08-12 17:54:56.459 Login time: Thursday, August 12, 2010 5:54:56 PM
. 2010-08-12 17:54:56.459 --------------------------------------------------------------------------
. 2010-08-12 17:54:56.459 Session name: D
. 2010-08-12 17:54:56.459 Host name: D (Port: -1)
. 2010-08-12 17:54:56.459 User name: (Password: No, Key file: No)
. 2010-08-12 17:54:56.459 Tunnel: No
. 2010-08-12 17:54:56.459 Transfer Protocol: SFTP (SCP)
. 2010-08-12 17:54:56.459 Ping type: -, Ping interval: 30 sec; Timeout: 15 sec
. 2010-08-12 17:54:56.459 Proxy: none
. 2010-08-12 17:54:56.459 SSH protocol version: 2; Compression: No
. 2010-08-12 17:54:56.459 Bypass authentication: No
. 2010-08-12 17:54:56.459 Try agent: Yes; Agent forwarding: No; TIS/CryptoCard: No; KI: Yes; GSSAPI: No
. 2010-08-12 17:54:56.459 Ciphers: aes,blowfish,3des,WARN,arcfour,des; Ssh2DES: No
. 2010-08-12 17:54:56.459 SSH Bugs: -,-,-,-,-,-,-,-,-
. 2010-08-12 17:54:56.459 SFTP Bugs: -,-
. 2010-08-12 17:54:56.459 Return code variable: Autodetect; Lookup user groups: Yes
. 2010-08-12 17:54:56.459 Shell: default
. 2010-08-12 17:54:56.459 EOL: 0, UTF: 2
. 2010-08-12 17:54:56.459 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes
. 2010-08-12 17:54:56.459 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No
. 2010-08-12 17:54:56.459 Local directory: default, Remote directory: home, Update: No, Cache: Yes
. 2010-08-12 17:54:56.459 Cache directory changes: Yes, Permanent: Yes
. 2010-08-12 17:54:56.459 DST mode: 1
. 2010-08-12 17:54:56.459 --------------------------------------------------------------------------
. 2010-08-12 17:54:56.459 Looking up host "D"

Thanks,
Jason
Advertisements
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24555
Location: Prague, Czechia
Please read FAQ. If that does not help, come back.
_________________
Martin Prikryl
niffer76

Guest


I am getting the same error. I am trying to automate the upload of a file to a STFP server. The script that I have created works just fine from a command prompt, but when I set up the Execute Process Task in SSIS, I just get the error message that the Server Host does not exist. I am using WinSCP 4.2.9.

I have set up the Argument as follows:

Arguments: -script = C:\mylocaldir\script.txt


Any ideas on how to get this to work???
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24555
Location: Prague, Czechia
Have you read the FAQ referenced above?
_________________
Martin Prikryl
bkamal

Guest


Hey, this FAQ didn't help me, i am still having the same issues, i am running the task on my remote desktop, winscp connects to the host fine but ssis does not
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24555
Location: Prague, Czechia
bkamal wrote:
Hey, this FAQ didn't help me, i am still having the same issues, i am running the task on my remote desktop, winscp connects to the host fine but ssis does not

Sorry, your post does not include enough information.

Please read how to troubleshoot problems with WinSCP. If it turns out that you are not able to help yourself, read how to ask for support or report bugs efficiently, so others can help you.
See also http://winscp.net/eng/docs/faq_script_vs_gui
_________________
Martin Prikryl
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License