sql server 2005 - SQL Agent job hangs on packages with Execute Process Task -


i have ssis package execute process task, runs 7zip exe zip file. works fine when run ssis. when run ssis sql agent hangs. assume permission. have given full control network services , sqlsvc folder has zip exe , folder extracting to. still no luck. should make ssis run thenter image description heree sql agent.

i have created proxy account has administrator privilege , change job step "run as" property new proxy account instead of sql agent service account. think sql agent service account doesnt have access run process. can change sql agent serice account group policies make work.


Comments

Popular posts from this blog

html - Sizing a high-res image (~8MB) to display entirely in a small div (circular, diameter 100px) -

java - IntelliJ - No such instance method -

identifier - Is it possible for an html5 document to have two ids? -