SSIS Execute Process Task giving a "The process exit code was "1" while the expected-CodePudding

I'm trying to use the "Execute Process Task" in SSIS to unzip a folder but I get the following error:

[Execute Process Task] Error: In Executing "C:\Program Files\WinRAR\WinRAR.exe" "e C:\Users\josh\Desktop\T-SQL_SQL Server\SSIS_RealWorld_Course_Udemy\Section 5 - Project 3\SharedFolder\Data20220703.zip -o " at "C:\Users\josh\Desktop\T-SQL_SQL Server\SSIS_RealWorld_Course_Udemy\Section 5 - Project 3\Processed", The process exit code was "1" while the expected was "0".

SSIS returns a message box which says: Unknown Option ""

and

WinRAR: Diagnostic returns a message box which says: No Archives Found

When I invoke the "Rar.exe" in the "Execute Process Task" I no longer get the two message boxes but it still fails to run.

The new error message is: [Execute Process Task] Error:

In Executing "C:\Program Files\WinRAR\Rar.exe" "e C:\Users\josh\Desktop\T-SQL_SQL Server\SSIS_RealWorld_Course_Udemy\Section 5 - Project 3\SharedFolder\Data20220703.zip -o " at "C:\Users\josh\Desktop\T-SQL_SQL Server\SSIS_RealWorld_Course_Udemy\Section 5 - Project 3\Processed", The process exit code was "7" while the expected was "0".

CodePudding user response：

I figured out why I was getting my original error.

The reason the SSIS Execute Process Task was giving me an error is because I had spaces in my file name. Once I removed the spaces everything worked normally.