Search code examples
etlazure-data-factory

Azure Data Factory Denied Delete File on VM with Delete Task


I have delete task on Azure Data Factory which I want delete files on VM with FileSystem as Linkedservice.

but i try debug this activity have error and denied permission like this: the file is forbidden to access

FYI, i can delete this file from VM with delete manual with press key del on keyboard. big many thanks to answer my question.


Solution

  • Make sure you have followed Prerequisites and the username and password provided at FileSystem linked service has enough privilege (write permission) to delete the source file. (latest version of self-hosted integration runtime, If the access is restricted to IPs that are approved in the firewall rules, you can add Azure Integration Runtime IPs to the allow list)

    You can verify access by using a lookup activity with same source file.

    In FileSystem linked service you would have to specify the path to a Folder, i.e. "the root path of the folder or the Azure File Storage endpoint" e.g. C:\[Folder]

    enter image description here

    Next in the Dataset you can further specify the relative directory or the File name.

    enter image description here

    enter image description here