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