First add a Get Metadata activity to your pipeline to retrieve the list of Excel files in the source folder.Before using the foreach activity you will have to use a GetMetadata activity to get the list of fileNames which you will be passing them to your source dataset and sink dataset dynamically for each iteration of the copy activity. xlsx file extension in your file name, instead of using recursive feature, you can use the ForEach activity to loop through the list of files and use the 'source' and 'sink' properties of the Copy Data activity to specify the source and destination file paths. This is the reason why you are seeing the original file name appended with. Please note that when you use recursive feature in copy activity, copy activity will copy all the files as per your source dataset configuration as is and will append any file extension specified in the sink dataset configuration. Welcome to Microsoft Q&A forum and thanks for reaching out here.Īs per my understanding, you are using 'recursive': true to copy multiple Excel files to your sink but changing the file extension from.

Convert txt to csv