471,066 Members | 1,164 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,066 software developers and data experts.

DTS - Schedule - Filepath - Permissions denied

I have created a dts package. It copies a file from a URL path
(\\server\folder\file.txt ) to a local folder (D:\folder)

It works okay when I run the package. But when I schedule it, it fails with
"Permission denied".

I made an even smaller script that just copies D:\folder\file.txt to
D:\folder\file2.txt. That works.

So obviously SQL server Agent cant access the URL folder.

When I schedule the job I can select a different owner. So (according to the
help file) that would mean I am in the Sysadmin role.

The sql server agent is started using an account that is a member of the AD
group "Domain Admins".
I am also in the AD group "Domain Admins".

So why do I get "Permission denied"?

/jim
Jan 15 '07 #1
0 975

This discussion thread is closed

Replies have been disabled for this discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.