In general copying files from one location to another is simple using Copy Activity of ADF. My problem statement is "I am trying to copy only excel files from Input folder to Archive folder, I would like to add, datetime stamp, otherwise if same file exists it overwrites the file"
Here is my pipeline
Step 1: GetFileList get the files names correctly
Step 2: Filter the files correctly as I am only interested in .xlsx files
Step 3: For each filter files I would like to copy
Step 4: Copy Activity "Source"
Step 5: Copy Activity "Sink"
"Sink DataSet config"
expression "@concat(replace(activity('FilterFiles').output,'.xlsx',''), '_', formatDateTime(convertTimeZone(utcnow(),'UTC','AUS Eastern Standard Time'),'yyyy-MM-ddTHHmmss'),'.xlsx')"
I get the validation check "Binary copy does not support copying from folder to file" All I am trying to copy the filer excel files to Archive folder with datetime stamp