I tried changing the account that the task runs under earlier this morning, but I was still having the compilation" error. I believe the way i was calling the vbs file was incorrect. Originally, I was executing this in the task's script editor window:
cscript.exe "c:\myFolder\myVBSfile.vbs"
I got it to work by changing it to the following:
Set oWsh = CreateObject("WScript.shell")
oWsh.Run("c:\myFolder\myVBSfile.vbs", 0, True)
Once that worked, I dressed it up a bit to pass the response/error codes to the executing task:
Dim oWsh, response
Set oWsh = CreateObject("WScript.shell")
response = oWsh.Run("c:\myFolder\myVBSfile.vbs", 0, True)
wscript.quit(response)
But what do you know... THEN I had an issue with the account it was running under! So thanks for the advice, it really helped.