Post a reply

Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)


Topic review


Re: SFTP - Get command doesn't create local directory.

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.

SFTP - Get command doesn't create local directory.

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?