FTP Task Editor (File Transfer Page)

 

Applies To: SQL Server 2016

Use the File Transfer page of the FTP Task Editor dialog box to configure the FTP operation that the task performs.

To learn about this task, see FTP Task.

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

ValueDescription
TrueThe destination path is stored in a variable. Selecting the value displays the dynamic option, RemoteVariable.
FalseThe destination path is specified in a File connection manager. Selecting the value displays the dynamic option, RemotePath.

OverwriteFileAtDestination
Specify whether a file at the destination can be overwritten.

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

ValueDescription
TrueThe destination path is stored in a variable. Selecting the value displays the dynamic option, LocalVariable.
FalseThe destination path is specified in a File connection manager. Selecting the value displays the dynamic option, LocalPath.

Operation
Select the FTP operation to perform. This property has the options listed in the following table.

ValueDescription
Send filesSend files. Selecting this value displays the dynamic options, LocalVariable, LocalPathRemoteVariable and RemotePath.
Receive filesReceive files. Selecting this value displays the dynamic options, LocalVariable, LocalPathRemoteVariable and RemotePath.
Create local directoryCreate a local directory. Selecting this value displays the dynamic options, LocalVariable and LocalPath.
Create remote directoryCreate a remote directory. Selecting this value displays the dynamic options, RemoteVariable and RemotelPath.
Remove local directoryRemoves a local directory. Selecting this value displays the dynamic options, LocalVariable and LocalPath.
Remove remote directoryRemove a remote directory. Selecting this value displays the dynamic options, RemoteVariable and RemotePath.
Delete local filesDelete local files. Selecting this value displays the dynamic options, LocalVariable and LocalPath.
Delete remote filesDelete remote files. Selecting this value displays the dynamic options, RemoteVariable and RemotePath.

IsTransferASCII
Indicate whether files transferred to and from the remote FTP server should be transferred in ASCII mode.

IsRemotePathVariable = True

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

Related Topics: Integration Services (SSIS) Variables, Add Variable

IsRemotePathVariable = False

RemotePath
Select an existing FTP connection manager, or click <New connection…> to create a connection manager.

Related Topics: FTP Connection Manager, FTP Connection Manager Editor

IsLocalPathVariable = True

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

Related Topics: Integration Services (SSIS) Variables, Add Variable

IsLocalPathVariable = False

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

Related Topics: Flat File Connection Manager, File Connection Manager Editor

Integration Services Error and Message Reference
FTP Task Editor (General Page)
Expressions Page

Community Additions

ADD
Show: