Copy Activity Failing while copying .zip file.

Hi Anonymous 

I managed to copy .zip file from one lakehouse to another lakehouse by a Copy data activity in a pipeline. Below are my settings for the activity. Hope it would be helpful.

Source:

Destination:

To use the Fabric data pipeline to copy a zip file from one place to another, you can follow these steps:

1. Configure the Source and Destination: In the data pipeline, choose your connection in the source or destination of the copy activity. Select the appropriate connection type, such as Azure Blob Storage, Azure Data Lake Storage, or any other supported storage service.

    

2. Select the File Format: In the File format section, choose Binary from the drop-down list. This is important because you are dealing with a zip file.

    

3. Configure Compression Type: In the File format settings dialog box, select ZipDeflate as the compression type. This will ensure that the zip file is handled correctly during the copy process.

    

4. Preserve Zip File Name: Under the Advanced settings in the Source tab, make sure to enable the option to preserve the zip file name as a folder. This will help maintain the structure of the zip file during the copy process.

    

5. Run the Pipeline: Once you have configured the source, destination, and file format settings, you can run the pipeline to copy the zip file from the source location to the destination location.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!