I have a workflow to shoot emails once process completes but we want to zip the files and send just to be sure in case the size is off limit.
How can i zip the outputs?
Zipping a file can be done using a Run Command tool that executes either the 7zip utility (if installed), or a PowerShell script.
7zip command reference: a (Add) command - 7-Zip Documentation
PowerShell script reference: Compress-Archive (Microsoft.PowerShell.Archive) - PowerShell | Microsoft Docs
Can you please do a sample workflow, I am still getting an error
Here's a workflow that zips the output of a dataset. The "Write Source" configuration is effectively an Output Data tool built into the Run Command tool that will be executed before the actual command is called. You can then read back in the dataset to continue additional processing through the "Read Results" configuration, which is effectively an Input Data tool that executes after the actual command.
The "Run Zip.bat" file referenced in the Run Command tool just contains this command:
"C:\Program Files\7-Zip\7z.exe" a -tzip "C:\Temp\output1.zip" "C:\Temp\output1.csv"
I am jsut getting the tzip dorectory
User | Count |
---|---|
56 | |
27 | |
25 | |
23 | |
21 |