sql server dts: Rundts from QA is giving "Access Deniad" -- sql server dts

Rundts from QA is giving "Access Deniad"

sasachi sachi sachi
9/29/2005 3:18:33 PM

sql server dts:

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

Re: Rundts from QA is giving "Access Deniad"

Sue Hoegemeier
9/29/2005 6:24:13 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
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.