Hi,
I'm attempting to copy a file from Azure file storage to a remote SFTP location using the Azure Copy Activity.
The sink dataset in the copy is using an SFTP linked service where the authentication is SSH Public Key.
When I run the activity it successfully copies the file to the root of the SFTP location.
However, when I try and copy to a sub directory on the SFTP location it fails with the error:
Failure happened on 'Sink' side. ErrorCode=SftpPathNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Can't find SFTP path '/OpenWork/test_report.txt'. Please check if the path exists. If the path you configured does not start with '/', note it is a relative path under the given user's default folder ''.,Source=Microsoft.DataTransfer.ClientLibrary.SftpConnector,''Type=Renci.SshNet.Common.SftpPathNotFoundException,Message=ObjectStore not found. Name: OpenWork,Source=Renci.SshNet,'
I know that the folder exists as I can see it using Filezilla (using the same authentication key). Using Filezilla I can also copy files to it, view the folder contents etc.
I've also noticed that within the Azure sink dataset, I am unable to Browse to the SFTP folder (neither the root nor the sub folder). In the case of browsing to the root I get:
Permission denied to access '/'. Access denied
Any idea why I can write to the root of the SFTP folder, but can't read from it, nor copy to the SFTP sub folder?
Thanks for any help



