Moving Multiple Excel files From folders in one container to folders in another container in same AZURE BLOB STORAGE through ADF

Question

I come across multiple files daily in a folder under a container of a storage account and after the completion on these files , I just want to move every files from the current container to another container under some directory but in same Azure BLOB STORAGE through ADF

I come across multiple scenarios for this process but each of them has copy activity in them and I came to know that copy activity doesn't support EXCEL as sink (weird)

Please help to resolve my issue ASAP

Answer 1

Hi anonymous user ,

Thanks for using Microsoft Q&A forum and posting your query.

Yes, you are correct. Currently Excel format is only supported as source and not as sink.

In case if you just want to move the files as is (just copy to sink and delete at source location), then you can use binary dataset in both source and sink of Copy activity and point to the folder that contains Excel files.

You will have to enable Delete files after completion option to move the file from source location to sink location

Note: Please note that when using Binary dataset in copy activity, you can only copy from Binary dataset to Binary dataset.

Here is another thread related to similar requirement - Archive an Excel File using Azure Data Factory

Hope this info helps. Do let us know if you have further query.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.