FTP Task Editor (File Transfer Page)

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.

Options

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

Value Description
True The destination path is stored in a variable. Selecting the value displays the dynamic option, RemoteVariable.
False The 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.

Value Description
True The destination path is stored in a variable. Selecting the value displays the dynamic option, LocalVariable.
False The 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.

Value Description
Send files Send files. Selecting this value displays the dynamic options, LocalVariable, LocalPathRemoteVariable and RemotePath.
Receive files Receive files. Selecting this value displays the dynamic options, LocalVariable, LocalPathRemoteVariable and RemotePath.
Create local directory Create a local directory. Selecting this value displays the dynamic options, LocalVariable and LocalPath.
Create remote directory Create a remote directory. Selecting this value displays the dynamic options, RemoteVariable and RemotelPath.
Remove local directory Removes a local directory. Selecting this value displays the dynamic options, LocalVariable and LocalPath.
Remove remote directory Remove a remote directory. Selecting this value displays the dynamic options, RemoteVariable and RemotePath.
Delete local files Delete local files. Selecting this value displays the dynamic options, LocalVariable and LocalPath.
Delete remote files Delete 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 Dynamic Options

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 Dynamic Options

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

See Also

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