Hi, Im trying to run my package through sql agent using dtexec command which runs fine through command prompt, but when running the command through sql agent the package fails with 'Access Denied'. When running throgh command prompt I'm using my windows login, when running through sql agent the Network Authority account is used. The package protection is encrypt sensative with password and this the dtexec command: dtexec /f "X:\Universal\MultipleDomainImport\MultipleDomainImport\Package.dtsx" /Decrypt MyPassword I given network authority full control of the directory where the package resides so what else can I do to get it working through sql agent. I want it to fun from the file system so I cant change the package to be stored on the sql server. Thanks

Create a proxy account and provide it the required access to the databases and the folders required. Now use this Proxy acount to run the job.My Blog | Ask Me | SSIS Basics

You can try to create a proxy that uses your credentials to run the job.MCTS, MCITP - Please mark posts as answered where appropriate.

Create a proxy account and provide it the required access to the databases and the folders required. Now use this Proxy acount to run the job.My Blog | Ask Me | SSIS Basics

You can try to create a proxy that uses your credentials to run the job.MCTS, MCITP - Please mark posts as answered where appropriate.

Thanks guys, the package now runs but sql agent reports the job as failing (even though it works successfully).

What's the error?MCTS, MCITP - Please mark posts as answered where appropriate.

It was the same error (access denied), however I restarted the sql agent and now it does not show the error.