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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-23 : 08:17:57
|
| Renu writes "I have created a DTS package on one server A. Package is moving data from text file (from Server B) to a table (on Server A). This package runs fine from enterprise manager from server and my desktop (another machine) but when I run using 'dtsrun utility' from my desktop. It gives error..."error opening data file : Access is denied". Path given for the text file is UNC. Can you please explain the cause of the problem?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-12-23 : 12:09:55
|
| Sounds permission related. What account is the SQL service running under?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
DTS package