SFTP - Get command doesn't create local directory.

Advertisement

nrees87
Joined:
Posts:
2
Location:
United Kingdom

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?

Nathan

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
29,540
Location:
Prague, Czechia

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.

Reply with quote

Advertisement

You can post new topics in this forum