Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mparter
Yak Posting Veteran
86 Posts |
 Posted - 2005-07-28 : 08:26:30
|
| I have a DTS package which creates a txt file and outputs it to a UNC path, e.g. \\server\data$\textfile.txtThe SQL server is running under a domain account called SVCSQL. This account also has permissions to the share above. This is setup OK as I've logged into a machine as SVCSQL and accessed the share successfully.However, I still keep getting an Error opening datafile: Access is denied.ANy ideas what else I can check? |
|
|
lizak
Starting Member
12 Posts |
Posted - 2005-07-28 : 09:23:13
|
| Is the SVCSQL account a member of the sa group? If not, I think the package will run will run under the proxy account and take it's authority from there. |
 |
|
|
|
|
|
DTS Permissions Issue