Scheduled transformation reading from different directory than transformation.

Both the ETL software and the execution agent are running on 6.4.5.68.

I have a transformation setup that takes an .xlsx file and does some SQL lookups to create a new .xlsx file used for importing into another service. This works perfectly if ran from the transformation.

The issue is that when I create a scheduled task for said transformation, instead of the reader reading from C:\ETL\Shopify\source.xlsx & the writer reading from C:\ETL\Shopify\destination.xlsx is set to, it instead attempts to read both from C:\Users\Administrator\Documents\.

I don't see any settings relevant to this that would cause this change in the schedule task entry. How can I fix this so the automation works properly?

Good Morning

Most likely it has something to with the directory connection you are using.

Please have a look a the following article

www.etl-tools.com/wiki/knowledgebase/iss...d-any-files-to-read/

This resolved the issue, thank you.