Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,426 questions
ADF error binary dataset does not support copying from folder to file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 38%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AzeemK
516
Reputation points
I am copying bunch of files from on prem share to blob storage , I am trying to rename files with replace function with dynamic parameter @filename @replace(dataset().file_name,'4194_','')
I m getting error binary dataset doesn't support copying from folder to file , I want to copy multiple files into ADLS folder and rename them using copy activity
{count} vote
-
Nandan Hegde 31,511 Reputation points MVP2021-08-30T14:55:01.62+00:00 Hey ,
Based on the error message it seems that your source in copy activity is a file folder .
Can you please confirm on that?
If that is the case, then you have to iterate over every file in source copy activity rather than folder. -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft 19,386 Reputation points Microsoft Employee2021-09-02T00:19:04.807+00:00 Hello @AzeemK ,
We haven’t heard from you on the last response from @Nandan Hegde and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu -
AzeemK 516 Reputation points
2021-09-02T05:38:03.943+00:00 I tried bunch of different way on source in copy activity still getting the same error , I have pretty simple get metadata activity and foreachloop with copy activity but for some reason it doesn't let me change the file name and extension
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 6%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
srv_costmgmt 5 Reputation points2023-03-04T21:36:07.6466667+00:00 Why is it so complicate to just copy a file from one container to the next? If it is not a csv or binary file you first have to create binary source and sink datasets - why?? And finally you can not use wildcards. What a crock!
Sign in to comment