SSIS execute task running wscript.exe hangs when started from SQL Server Agent
Without some detail of error messages it is hard to know for sure what's going wrong, however it sounds like it may well be either a permissions issue or a problem running the script on that host.

When an agent job runs, it will run under the agent service account or the credential used to create the proxy that the step runs as.

This means that the account will need permissions on wscript.exe and the script that wscript.exe runs.  I think my next step would be to do the following test:


create a new credential using your login
use this credential to create a proxy
run the step of the agent job as this proxy


If this doesn't work, try running the script directly on the host where SQL Server is running - the outcome of this would indicate if there is an issue with the script being able to run from that host