Thanks,
I have to admit, that sort of makes things a bit more confusing.
Why does it work flawlessly when I manually execute it from my default Python shell and not when I use the task scheduler?
I have ran it both directly from the desktop software and from the python shell without any issues. I'm not at work today, so I will have to wait until tomorrow to check some settings. However I know the server is 64 bit and I am running it via the desktop software on the server. Granted when I run the task scheduler I am running it via the 64 bit option.
Do you think it will run if I specify the 32 bit option or try to let the server choose?
Yes, in the task scheduler I am point to the 64 bit python option on the left side of the window and on the right side I am giving it the path to the python script, no bat file.
So tomorrow I will test a few of your suggestions out and see what happens.
Come to think about it, only about a third of my scripts run via the task scheduler. All of them are via the 64 bit option. So I stick with the 32 bit for them all if its possible or just use the cmd line and let the server sort it out?
Thanks again for your help!