there are 10 files with names like Ex: India, Australia, Africa, South Korea, Afghanistan, Canada, Ireland, USA, Scotland, Oman these files will have some sample data then in azure SQL will have a table with 5 rows containing names from those 10 files like India, South Korea, Canada, USA, Oman we have to create a pipeline in such a way it will read that 5 file names from SQL server table and pass that value store it in a variable or parameter then copies those 5 files from ADLS container and stores it in another container in 5 folders.

I have taken a Lookup activity to retrieve the file names from the SQL table and store them in an array variable. Next, taken a ForEach activity to iterate over each file name in the array. Inside the ForEach loop, used a Get Metadata activity to gather information about the files in the source ADLS container, followed by a Copy activity to copy the files to another ADLS container based on the retrieved file names. But in copydata activity in source it is asking for wildcard path without using wildcard path how to solve this.