Python Paramiko, PermissionError: [Errno 13] Permission denied when get files from remote server

Question

import paramiko, os
paramiko.util.log_to_file('E:\Automation\paramiko.log')
from stat import S_ISDIR
host = "xx.xx.xxx.xxx"
port = 22
transport = paramiko.Transport((host, port))
password = "password"
username = "username"
#transport.set_missing_host_key_policy(paramiko.AutoAddPolicy())
transport.connect(username = username, password = password)
sftp = paramiko.SFTPClient.from_transport(transport)

def sftp_walk(remotepath):
    path=remotepath
    files=[]
    folders=[]
    for f in sftp.listdir_attr(remotepath):
        if S_ISDIR(f.st_mode):
            folders.append(f.filename)
        else:
            files.append(f.filename)
    if files:
        yield path, files
    for folder in folders:
        new_path=os.path.join(remotepath,folder)
        for x in sftp_walk(new_path):
            yield x


for path,files  in sftp_walk("." or '/SourceData/CSV.EXTRACT/'):
    for file in files:
        sftp.get(os.path.join(os.path.join(path,file)), 'E:\InsightImport\CSV_EXTRACT')

E:\Automation>python dw.export.py
Traceback (most recent call last):
  File "dw.export.py", line 33, in <module>
    sftp.get(os.path.join(os.path.join(path,file)), 'E:\InsightImport\CSV_EXTRAC
  File "C:\Users\svc-cbsbir\AppData\Local\Programs\Python\Python37\lib\site-pack
    with open(localpath, "wb") as fl:
PermissionError: [Errno 13] Permission denied: 'E:\\InsightImport\\CSV_EXTRACT'

Answer 1

The second argument to SFTPClient.get is a path to a local file. While you seem to pass a path to a directory.

Also, you should not use os.path.join on SFTP paths. The os.path.join is for local paths. SFTP always uses forward slashes, while os.path.join uses local OS-specific separators (back slashes on Windows).

sftp.get(path + '/' + file, os.path.join('E:\InsightImport\CSV_EXTRACT', file))

(or you might use PosixPath)