Hi there, I have an integration job which imports a CSV file from OneDrive to an Azure SQL database. I can set this up fine and, when run manually, it works perfectly.
However, when run on a schedule, it fails, with the error 'item does not exist'. Looking at the Import Task, the package seems to have lost its reference to the CSV file in OneDrive. After re-selecting the file from the drop-down and re-saving, the job can again be run manually fine. However, the job will again fail when run on a schedule.
This is making this un-useable and need help with this asap please.