Azure data factory copy excel files

sakuraime 2,321 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.
10,075 questions
0 comments No comments
{count} vote

Accepted answer
  1. Nasreen Akter 10,791 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