Search code examples
excelazureazure-data-factoryazure-data-lake

Get Meta data in Azure Data Factory is not giving me my multiple excel files successfully

I am trying to process multiple excel files in ADF to utilize them in a copy data activity to blob storage. Here is how my hierarchy is structured :

  • My source is an excel sheet coming from SFTP server (linked service).
  • File path: unnamed folder with multiple .xlsx files. Inside those files, the sheet name varies between sheet1 and table1.

I am trying to create get metadata to get all those files to pass them into a copy activity, but my metadata is never succeeding

Attached below is an elaboration about the problem: enter image description here

enter image description here

enter image description here

Solution

  • If you only want to copy all excel files from SFTP to Blob Storage, there is no need to use Get Metadata activity.

    Please try like this:

    1.create binary format dataset enter image description here

    2.choose Wildcard file path when copy data enter image description here

    3.sink to your Blob Storage.