A Command task can succeed even if the command is unsuccessful or if you provide a working directory that is not valid. The Is Successful general output indicates whether the Command task ran successfully. The Exit Code task output indicates whether the command ran successfully. You can use a conditional sequence flow to check if both the Command task succeeded and if the command returned an exit code of 0.

For example, create a boolean workflow variable that captures the Is Successful output returned by the Command task. Create an integer workflow variable that captures the exit code returned by the command. Create the following expression in the outgoing conditional sequence flow from the Command task:

The Data Integration Service runs the next task if the previous Command task ran successfully and if the command returned an exit code of 0.