Execute process task to call a command line zip utility

Active 8 years, 3 months ago. Viewed 17k times. Improve this question. Community Bot 1 1 1 silver badge. MaxGeek MaxGeek 1, 6 6 gold badges 21 21 silver badges 32 32 bronze badges. What version of SQL Server are you using? Add a comment. Active Oldest Votes. Depends on Ionic's DotNetZip library. This is version 1. Hi Andrea, follow the below yourtube link, hopefully that might help you.

Well, it depends on a zipping utility whether it supports adding files to an archive. Thursday, May 2, PM. Thanks, Anil thanks very much! Saturday, May 4, AM. Hi Andrea, try the below link, its script task having vb. ToString Then Dts. ToString End If Dts. Success End Sub hopefully this might help you..

Saturday, May 4, PM. Thanks, Anil sorry Anil, i made a mistake, i don't mean to delete file,i want zip all files into one zip that last modify date was before In WinZip command line the syntax is winzip32 [-min] action [options] filename[.

For example, I choose to hide the command line window for 7-Zip when it executes. My result is shown in Figure Viewing the source and destination directories, we see the file was successfully moved — shown in Figure Figure 7: The File, Compressed! This article has demonstrated another way you can use the Execute Process Task to compress files for archiving. Archiving files after loading the data they contain is a common practice in data integration. Have you tried other executables, such are calling robocopy.

If you know a trick to getting it to run I would really appreciate it. Note: I tried with Execute process task whereas in connection B my project folder is in share only , but it could not find the path it shows error. I need to call the server 2 exe file in server 1 which task i must use? Error i am getting when i execute : could not find the part of the path in Command prompt while executing the exe The exe file is in share folder.

This task is open source on GitHub. Feedback and contributions are welcome. You need at least one agent to run your build or release. See Troubleshoot Build and Release. See Agent pools. This can be fixed by adding a trusted root certificate. See Node. See Set variables in a pipeline for instructions on setting a variable in your pipeline. Some of these features are available only on Azure Pipelines and not yet available on-premises.

Some features are available on-premises if you have upgraded to the latest version of TFS.