SSH Execute Task

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Questions?

Overview

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


Setup

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

Parameters

Name

Specify the task name.

Description

Specify the task description.

ExecConnection

Selects an existing SSH connection manager, or you may click <New connection...> to create a new connection manager.

Related Topics: SSH Connection Manager

StopOnFailure

Specify whether or not the SSH Execute Task terminates if the command fails.

CommandType

Select the source type of the command to be run by the task. This parameter has the options listed in the following table.

Option Description
Direct input Set the command in the task. Selecting this option displays the dynamic parameter CommandDirect.
File connection Select a file that contains the command. Selecting this option displays the dynamic parameter CommandFile.
Variable Set to a variable that defines the command. Selecting this option displays the dynamic parameter 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 you may click <New connection...> to create a new connection manager.

Related topics: File Connection Manager

CommandVariable

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

Related Topics: Integration Services Variables, Add Variable

OutputVariable

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

Related Topics: Integration Services Variables, Add Variable

ErrorVariable

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

Related Topics: Integration Services Variables, Add Variable