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,562 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
Azure Data Lake Storage
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,651 questions
{count} vote
-
Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator2021-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,491 Reputation points Microsoft Employee Moderator2021-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 10 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
Sign in to answer