• Ok, so create the variable.

    Then Configure your ftp task to get the name of the file from the variable.

    Create a script task that goes out to the drive and looks for the *_Layout...xlsx file.

    then once it finds it, gets the file name and updates the variable with the name.