@Prapul Kumar Dongari Welcome to Microsoft Q&A forum and thanks for reaching out here.
ADF uses .net build-in unzip tool to extract the zip files. Given the error message "Message=The file '*************' is not a valid Zip file with Deflate compression ethod.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.IO.InvalidDataException,Message=End of Central Directory record could not be found", it indicates that the source zip file is somehow not in a healthy status.
Or file is corrupted (assuming based on this message: **Message=End of Central Directory record could not be found**
) due to unsupported compression type being used while generating the zip file.
Please note that the internal zip library of Azure Data Factory only supports "deflate" compression. In case if you source file is being compressed by an algorithm other than "deflate", then it results in such an error.
Please refer to this documentation for more details: Unsupported compression causes files to be corrupted
Hence, I recommend troubleshooting on how your source file being compressed (You can use some third party tool like "7zip" to open the zip file, and it will show the actual compression algo). If it is not Deflate compression then it is not supported by ADF.
Hope this info helps. In case if your source zip file uses "deflate" method for compression but still notice this behavior in ADF, then I recommend filing a support ticket for deeper investiagation. And in case if you don't have a support plan, please let me know here.
Please don’t forget to Accept Answer
and Yes
for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.