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

Question

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:

Answer 1

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

2.choose Wildcard file path when copy data

3.sink to your Blob Storage.