| Sue Hoegemeier 2005-09-29, 8:24 pm |
| Probably because you are executing the package under
different security contexts in the two situations.
When you execute a package manually, it executes under your
security credentials and from the PC where you are running
Enterprise Manager and executing the package.
When you execute it manually using xp_cmdshell, it will run
from the server and under the security context of the SQL
service account if you are a sysadmin or under the security
context of the proxy account if you are not a sysadmin.
You need to look at the permissions of the service account
or the proxy account.
-Sue
On Thu, 29 Sep 2005 15:18:33 -0700, sasachi sachi sachi
<sasachi@getmail.com> wrote:
>
>
>Hi everybody
>
>I created a dts package to transfer data from a fixed width text file
>located on a sharable folder in a central server. When I run the dts
>package from DTS designer the package gets executed successfully where
>as when I run the same dts package from query analyzer using xp_CmdShell
>procedure I am getting "Access Deniad" error I am puzzled with this
>situation. How come the package ie executing successfully in Enterprise
>manager and is getting Access Deniad in Query analyzer? Does anybody
>experienced this before and Does anybody can pass me a clue to resolve
>this issue?
>
>Thank you,
>Sree
>
>*** Sent via Developersdex http://www.droptable.com ***
|