Execute Process Task

Execute Process Task is used to execute applications in Control Flow and is often used to decompress encrypted data.

1 Task RequireFullFileName attribute: whether a complete file path is required, and if the file is not found under RequireFullFileName, the file fails. File is the application file executed by Task, and the default value is True.

2 the Path Executable attribute: executable file name and executable file name, no parameters can be provided.

3Permanent arguments property: parameters of the executable file

4According WorkingDirectory attribute: Path required for executable file execution

5 Executable StandardInputVariable: a variable passed in as a parameter. Using the variables of SSIS, you can dynamically pass values to the parameters of Executable.

6StandardOutputVariable: the variable used to receive the output of Executable

7StandardErrorVariable: used to capture variables that have errors in the execution of Executable

8GramFailTaskIfReturnCodeIsNotSuccessValue: whether to verify the execution result of Executable, Indicates whether the task fails if the process exit code is not the same as the success exit code

9 Execute Process Task SuccessValue property: Execute Process Task fails if the exit code from Executable is different from the value of the SuccessValue property. The default value is 0, which means that Task successfully executed Executable.

10 Timeout attribute: the Timeout attribute represents the timeout time that the Executable executes, in s, and the default value is 0, indicating that the process can run without restriction. This attribute is used in conjunction with the TerminateProcessAfterTimeout attribute, and if the TerminateProcessAfterTimeout attribute is True, the process is terminated after the timeout.

11PowerWindowStyle property: set to Hidden, which means the window is hidden. In the official version, set this property to Hidden.

-