I have a python script on a server. It places data from MS SQL Server into a df, then creates a CSV file to a location on the server, and then uploads the CSV file to an FTP site. It checks if there is already a file in that location before creating the CSV, and deletes it if there is.

I want Windows Task Scheduler to do this. I have a service account that I want to set the task up with, but if I use that account, the task produces 0x1. If I use my own account, the task executes fine, suggesting there is a permission problem with the service account.

I have made sure the service account has full permissions in the location where the CSV would be deleted from, and created to. I have also made sure the account has permissions in the database that the script selects data from. What else can I check?