SCP Task

Overview

SCP Task is SSIS Control Flow task for secure copying of files with SSH server. For more advanced functionality check SFTP Task.

Setup

Use the General page of the SCP Task Editor dialog to configure the options needed to copy files with remote SSH server.

Options

Name

Specify task name.

Description

Specify task description.

StopOnFailure

Specify whether the SCP Task terminates if copying fails.

Action

Specify task action. This property has the options listed in the following table.

Value	Description
Send files	Send files. Selecting this value displays the dynamic options IsLocalVariable, Local, LocalVariable, ScpConnection, IsRemoteVariable, Remote, RemoteVariable.
Receive files	Receive files. Selecting this value display the dynamic options IsLocalVariable, Local, LocalVariable, ScpConnection, IsRemoteVariable, Remote, RemoteVariable.

IsLocalVariable

Indicates whether the local path is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The local path is stored in a variable. Selecting the value displays the dynamic option LocalVariable.
False	The local path is specified in a File connection manager. Selecting the value displays the dynamic option Local.

Local

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

Related topics: File Connection Manager Editor

LocalVariable

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

Related Topics: Integration Services Variables, Add Variable

ScpConnection

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

Related Topics: SSH Connection Manager

IsRemoteVariable

Indicates whether the remote path is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The remote path is stored in a variable. Selecting the value displays the dynamic option RemoteVariable.
False	The remote path is explicitly specified on the remote server. Selecting the value displays the dynamic option Remote.

Remote

Select remote path on the remote server.

RemoteVariable

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

Related Topics: Integration Services Variables, Add Variable