How to Download a file on the web and compress it using SSIS

SSIS PowerPack
1

Introduction

In this article, we will demonstrate how to download files from the web using ZappySys SSIS tasks and then compress them using the ZS Compression Task in SSIS. This method allows you to automate downloading files and managing their compression within your SSIS package.

Prerequisites

  • SSIS PowerPack: Download and install the ZappySys SSIS PowerPack from here.

Method 1: Downloading Files Using the REST API Task

  1. Drag and drop ZS REST API Task from the SSIS Toolbox into the Control Flow.

  2. Double-click the task to edit. In the Request Settings tab, enter the following URL to download the file: https://zappysys.com/downloads/files/nw.zip

    image
    image838×735 36.8 KB

  3. Go to the Response Settings tab.

  4. Check the Save Response Content option.

  5. Set the Save Mode to “Save to file.”

  6. Specify the target file path, e.g., c:\ssis\nw.zip.

  7. Check the Treat response as binary option to download binary files such as ZIP, images, or media files.

    image
    image838×334 22.8 KB

  8. After configuring the task, click OK and execute the package. It will download the file to the specified location.

Downloading From Secure Pages

If you need to download files from a secure page that requires authentication, follow these steps:

  1. Use an HTTP Connection or OAuth Connection in the REST API Task for secure file downloads.
  2. Configure the appropriate connection settings for authentication.

Method 2: Downloading Files Using the Download File Task

  1. Drag the ZS Download File Task from the SSIS Toolbox into the Control Flow.

  2. Set the Url Access Mode to Direct.

  3. Enter the following URL: https://zappysys.com/downloads/files/nw.zip

  4. Specify the target file path, e.g., c:\ssis\nw.zip.

    image
    image588×555 19.7 KB

  5. Click OK and run the package to download the file.

Compressing Files Using the Compression Task

Once the file has been downloaded, you can compress it using the ZS Compression Task in SSIS.

  1. Drag and drop the ZS Compression Task from the SSIS Toolbox into the Control Flow and connect with the REST API or Download file Task.

  2. Double-click the Compression Task to open the editor. Select the Compress File(s) option. Choose between:

    • Create a single archive: Compress multiple files into a single ZIP archive.
    • Create multiple archives: Compress each file individually.

  3. Set the file source from the previous step and the target file path for the compressed archive: D:\Zappysys\Test\new.zip.

  4. Chose the OverwriteAll option

    image
    image638×595 26.5 KB

  5. After configuring the task, click OK and run the package. The file will be compressed as specified.
    image

Additional Compression Options

  • Compress with Folder Structure: Preserve the folder structure when compressing.
  • Uncompress Files: Decompress one or more files to a specified location.
  • Variables and expressions in the path: You can check our article here about how to use variables and expressions in the path

Video Tutorial

Conclusion

You can easily automate downloading files from the web and compressing using ZappySys SSIS PowerPack components such as the REST API Task, Download File Task, and Compression Task. This is an efficient way to manage large datasets or files within your SSIS workflows. If you need further assistance, contact the ZappySys support team.

References