I call .xlsm, which is automatically executed by the SSIS Process Execution task.
Then I register this to the SQL Server Agent job.
It works fine when I am logged in.
However, if it is run when I am logged off, such as during a scheduled run, it hangs up.
I can see the Excel process in Task Manager, but it is not actually running (CPU usage is 0% all the time).
What are the possible causes?
Note that I am not using a user DSN, so that is not the cause of the problem.
Thanks.