SCP Task

Overview

The SCP Task is an SSIS Control Flow task for secure copying of files with an 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 a remote SSH server.

Parameters

Name

Specify the task name.

Description

Specify the task description.

StopOnFailure

Specify whether the SCP Task should terminate if copying fails.

Action

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

Option Description
Send files Send files. Selecting this action displays the dynamic options IsLocalVariable, Local, LocalVariable, ScpConnection, IsRemoteVariable, Remote, RemoteVariable.
Receive files Receive files. Selecting this action displays the dynamic options IsLocalVariable, Local, LocalVariable, ScpConnection, IsRemoteVariable, Remote, RemoteVariable.
IsLocalVariable

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

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

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

Related topics: File Connection Manager Editor

LocalVariable

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

Related Topics: Integration Services Variables, Add Variable

ScpConnection

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

Related Topics: SSH Connection Manager

IsRemoteVariable

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

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

Select the remote path on the remote server.

RemoteVariable

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

Related Topics: Integration Services Variables, Add Variable