Not able to push csv file from ADLS gen2 to sftp through copy task

Question

Hi,

We are pushing CSV files from ADLS gen2 location to SFTP location.

Sink linked service is through Self Host (User Id and Password) - Successful

We are trying to move the file on SFTP root location.

While running the pipeline it shows following error:

Copy failed with error: 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Permission denied to access'

Answer 1

Hello @Hemendra Singh Patel , Thanks for the question and using MS Q&A platform. As we understand the ask here is to get away with the error, please do let us know if it's not accurate.

From the error it looks that the issue is on the sink side and so you should check the permission for the user which Azure data factory is using upload the file .

A simpler test will be to login to the sftp with the user and try to upload a test file and see if that succeeds.
Please do let me know how it goes .

Thanks Himanshu

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators