Topic "SFTP - Get command doesn't create local directory."

Author Message
nrees87
[View user's profile]

Joined: 2014-08-14
Posts: 2
Location: United Kingdom
I have a job set up in SSIS that loops through a database which contains a mix of FTP and SFTP accounts. The SSIS job creates a temp text file containing the script for WINSCP to execute via the command line (Execute Process Task).

When an FTP account is used, the resulting GET request creates the local directory if it doesn't exist.

However when an SFTP connection is established - it merely returns "cannot find file specified" error.

Can anyone shed some light on this before I pull what's left of my hair out?

Nathan
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24991
Location: Prague, Czechia
In general the target local directory (the root destination path) has to exist prior to the download. FTP is an exception, it creates the folder. Subfolders are created automatically with whatever protocol.
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