Hello anonymous user,
Yes, you can use 'Childitems' instead of 'iteamName'.
The below steps helps to extract Date from FileName in Copy Activity from a folder.
Step1: Use Get Metadata Activity to fetch child Items from folder. Dataset should point to folder in which we have our files.
Step2: Create a variable to store date.
Step3: Pass GetMetadata ouput childItems to ForEach Activity
Step4: Inside ForEach, Use Set Varible activity to fetch date from Filename and store it in variable.
Step5: Inside ForEach, Use Copy activity with Dataset Dynamically pointing to file and add additional column for the Date.
ds_SalesExcel Data set details
Hope this helps. Do let us know if you any further queries.
---------------------------------------------------------------------------
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.