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 Variables, Add Variable

IsRemotePathVariable = False

IsLocalPathVariable Dynamic Options

IsLocalPathVariable = True

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

    Related Topics:Integration Services Variables, Add Variable

IsLocalPathVariable = False

See Also

Reference

FTP Task Editor (General Page)
Expressions Page

Other Resources

Integration Services Error and Message Reference

Help and Information

Getting SQL Server 2005 Assistance