hitesh.ramchandani (8/16/2013)
Koen Verbeeck (8/16/2013)
anil.kumars13 (8/16/2013)
Thank you, I came up with the same issue. but got it resolved by your post.Thank you,
Anilkumar
Remember that you now gave everyone full access to your data in the file.
Just sayin'...
Joen, can you elaborate how does everyone get access to the data, when only the specific user under whose account the package is run is added to power Users group? Does'nt seem to make a point..
I wasn't referring to your post, but to the post by Eric:
I was able to fix the issue by giving full control to the 'users' group to the text file.
Doing this gives everyone who is a user full access to the data in the file.
It's much saver to use proxies in the SQL Agent job and give that proxy account specific permissions on that file/directory.
Even adding the proxy account to the Power User group might be insecure, as you're giving that account potentially too much permissions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP