SSH Execute Task

Overview

SSH Execute Task is SSIS Control Flow task for secure execution of shell commands on a remote SSH server.

Use the General page of the SSH Execute Task Editor dialog to configure the options needed to run a command on remote SSH server.

ExecConnection

Select an existing SSH connection manager, or click <New connection...> to create a connection manager.

Related Topics: SSH Connection Manager

StopOnFailure: Specify whether the SSH Execute Task terminates if command fails.

CommandType

Select the source type of the command that the task runs. This property has the options listed in the following table.

Value	Description
Direct input	Set the command in the task. Selecting this value displays the dynamic option CommandDirect.
File connection	Select a file that contains the command. Selecting this value displays the dynamic option CommandFile.
Variable	Set to a variable that defines the command. Selecting this value displays the dynamic option CommandVariable.

CommandDirect: Type the command to execute in the option box or click the browse button (...) to type the command in the Enter the command dialog.

CommandFile

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager

CommandVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

OutputVariable

Select an existing user-defined variable, or click <New variable...> to create a variable where command output is stored.

Related Topics: Integration Services Variables, Add Variable

ErrorVariable

Select an existing user-defined variable, or click <New variable...> to create a variable where command error message is stored.

Related Topics: Integration Services Variables, Add Variable