I have a problem with sql server 2012 SSIS package which has execute step running
When I run this package from BIDS everything works fine, when I start package from SSIS it also starts without any problem. But once I start this package as a step in sql agent job - it hangs, and do nothing. The problem is with execute step, once I disable it in package SQL agent executes package fine.
I've tried to add SQL Agent's credentials security rights on folder with
wscript.exe utility, I've also tries to add sql server proxy account. But still nothing helped.
Can you please advise how can I fix it?
Once I run package in Dev Tools everythings works just fine, but running package from sql server job causes
wscript.exe process hang in process list in a taskmanager. Once I manually kill this process job stops working.
I assume that this behaviour is somehow related to lack of permissions, but even new credentials didn't work for me. Or maybe wscript utility asks for some promt, though running the same script from command line didn't show any.