Azure Data Factory upload Zip File to SFTP

0
votes

I need some help pointing me in write direction. I have a zip file with CSV file inside the zip file. CSV file name is 'PRODDATA.CSV'. Zip File name is PRODDATA20210223.zip

When I use Copy Activity with ZipDeflate as source in the SFTP destination it creates a zip file with the proper name PRODDATA20210223.zip but inside the zip file it puts data_.txt inside the zip file. It doesn't retain the CSV file. The text file is actually is correct CSV format.

Can someone point what I'm doing wrong or how can I make sure the zip file created and inside it still retains the CSV extension and the name.

4
azure-data-factoryazure-data-factory-2azure-data-factory-pipeline

4 Answers

0
votes

I tested and repeat your error.

Please don't set the compression type ZipDeflate in Sink dataset.

Or you will get the output file like this: enter image description here

The correct sink dataset settings: enter image description here

enter image description here

Then the output file could be: enter image description here

Update:

Source settings and dataset: enter image description here

enter image description here

Please correct my if I misunderstand your question.

HTH.

0
votes

enter image description here

Second screen shot for the Source .....

0
votes

[![enter image description here][1]][1]

Second screen shot for the Source .....
[1]: https://i.stack.imgur.com/XXsWJ.png

0
votes

enter image description here

Sink 1st Screen Shot.... Creating Zip File...Then it worked

enter image description here