question

chaisen1805 avatar image
0 Votes"
chaisen1805 asked chaisen1805 commented

Archive an Excel File using Azure Data Factory

Archive an Excel File using Azure Data Factory.
Can you please list out the process.

As excel is not supported in sink.
Any suggestions?

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered chaisen1805 commented

Hi @chaisen1805,

Thanks for your ask and using Microsoft Q&A forum.

If you are just trying to move (copy to target and delete from source location) excel file from Location A to Location B (Archive) using ADF, then you can use copy activity with source and sink as binary datasets pointing to respective Excel file location.

98405-image.png

In case if I misunderstood your requirement please do correct me by providing a bit additional information about your use case/requirement which would help us to assist you better?


Thanks



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



image.png (127.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @chaisen1805,

Following up to see if the above suggestion was helpful? Do let us know if you have further query.

Thanks

0 Votes 0 ·

That worked thanks!

0 Votes 0 ·