Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
How to copy multiple files from .zip folder on a ftp server
![](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(0, 7.000000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
bk
466
Reputation points
Hi All,
I have to copy files from a .zip folder to ADLS Gen2 folder. The .zip folder resides on an FTP server. When i downloaded and extracted locally there are 25 files (.csv) all of these need to be copied (they have different metadata). What i done so far.
1) Created Linked service successfully.
2) Created source data set using (compression type "zipdeflate").
Step 2 is where i am having an issue , when i click on import schema , i see the columns from the first file in the list of 25 files, my question is how to copy all these 25 files. Please advice.
Thanks
Azure Data Factory
{count} votes
-
![](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' %3EH%3C/text%3E%3C/svg%3E)
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator2021-08-26T21:35:42.763+00:00 Hello @bk ,
Thanks for the ask and using the Microsoft Q&A platform .
Are you selecting the binary file type ? if not can you please the same and try again .
Please do let me know how it goes .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members -
bk 466 Reputation points
2021-08-31T14:45:30.943+00:00 @HimanshuSinha
Thanks , but all it did was to COPY the .zip folder into ADLS Gen 2. My ask is- There is a zip folder on an FTP Site with multiple files.
- I need to unzip and copy all these files into ADLS
Thanks
-
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator
2021-09-09T20:30:40.063+00:00 Hello @bk ,
Apoloziges for the delayed response .Please set the compression type property as ZipDeflate and that should do the trick .
https://learn.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs-legacy#compression-supportThanks
Himansh -
HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator
2021-09-14T16:28:20.823+00:00 Hello @bk ,
We haven’t heard from you on the last response 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
Sign in to comment
Sign in to answer