Delete activity failed for deleting files via on-premises

[quyendang]

As the tittle suggested, delete activity failed when I tried to delete files in a Folder type data gateway connected to an on-premises data gateway. Copy activity using the same data gateway works just fine.

The error is: "Failed to execute delete activity with data source 'FileServer' and error 'Error occurred when trying to access the file in Folder 'E:\[FolderName]\[FileName].txt', File filter: ''.
The directory name is invalid.
'. For details, please reference log file here: ."

Feels like it is something very specific with delete activity in Fabric. Anyone has the same issue?

[quyendang · Accepted solution]

The solution was just folder/file access for users on the local machine we used. 🙂 Once that was arranged it's solved. (user was not allowed to modify files)

[v-prasare]

Hi @quyendang,

 We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are

[v-prasare]

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

@suparnababu8, Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are

[suparnababu8]

Hi @quyendang 

You can give the folder path without metioning the E. for example insted of using the E:\[FolderName]\[FileName].txt', File filter:

You may use [FolderName]\[FileName].txt and it may work.

If you havn't refered this, Please refer this thread azure - ADF Delete Activity not deleting Folders - Stack Overflow It may helps you.

Please let me if it works.

Thank you!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!