For a more integrated experience, many developers use third-party "PowerPacks." Tools like the or the ZappySys SSIS Zip File Task provide a drag-and-drop interface specifically for compression.
You configure the task to run 7z.exe with specific arguments (like a for add) and pass in your file paths as variables. Pros: Free and highly customizable. Download SSIS 292 zip
Using SSIS to zip files and email the zipped files - SQLServerCentral For a more integrated experience, many developers use
Streamlining Data Workflows: How to Zip and Unzip Files in SSIS For a more integrated experience