Hi having an issue where my FME data update job is running fine from Desktop when you click run. But when I published the job to FME server and set up an automation to run nightly, it seems to be pulling in old data when it runs.
The job reads an excel spreadsheet in a folder and plots it and inputs the output data into our SDE. It seems like when I publish to FME server the excel spreadsheet is not being picked up live from its file location.