question

bk-4602 avatar image
0 Votes"
bk-4602 asked HimanshuSinha-MSFT commented

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

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
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @bk-4602 ,
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 .



126829-image.png


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


0 Votes 0 ·
image.png (53.7 KiB)

@HimanshuSinha-MSFT
Thanks , but all it did was to COPY the .zip folder into ADLS Gen 2. My ask is
1) There is a zip folder on an FTP Site with multiple files.
2) I need to unzip and copy all these files into ADLS

Thanks

0 Votes 0 ·

Hello @bk-4602 ,
Apoloziges for the delayed response .

Please set the compression type property as ZipDeflate and that should do the trick .
https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs-legacy#compression-support

Thanks
Himansh

0 Votes 0 ·

Hello @bk-4602,
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

0 Votes 0 ·

0 Answers