'task scheduler that runs console application

I have a console app. I need to run every day looking for an .xlsx file on a network shared drive and import the data to SQL. it works great if a network account is actually logged into the server when the task is scheduled to run. I have set the account setting to use my account as well as highest priv. whether user is logged in or not. I read a task scheduler uses local system account so that's why it can't see a shared drive. any ideas what I can do to fix this?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source