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

Author Message
[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?

[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24736
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.

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!


About donations

$9   $19   $49   $99

About donations


WinSCP Privacy Policy

WinSCP License