How to copy multiple files from .zip folder on a ftp server

bk 461

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

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-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 461 Reputation points

2021-08-31T14:45:30.943+00:00
@HimanshuSinha-msft
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-msft 19,376 Reputation points Microsoft Employee

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-support

Thanks
Himansh
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

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