Share via

Azure data factory copy excel files

sakuraime 2,331 Reputation points
2021-03-19T01:45:07.347+00:00

I have some excel files on the on-prem sftp , and want to copy to blob storage same as excel files.

what activity and dataset file format should I use ?

As I know excel is not a supported sink file format .

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,161 questions
0 comments
Accepted answer
  1. Nasreen Akter 10,811 Reputation points
    2021-03-19T01:55:09.12+00:00

    Hi @sakuraime ,

    You can use Binary Dataset both in the Source and Sink side in the CopyActivity to move files from on-prem to blob storage.

    Thanks!

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.