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-05-16 : 09:40:55
|
| Mohamed writes "I created simple DTS Package which exports table contents to text file, but the destination is shared folder on another machine not local, it is running successfully from DTS designer or dtsrun Utility but when scheduling it to run as job the job fails and get the error "Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider "thanks in advance for help" |
|
|
mtomeo
Starting Member
30 Posts |
Posted - 2003-05-16 : 10:32:37
|
| Does the ID you are executing the DTS job under have the proper authority to get to the destination folder? |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-16 : 14:42:04
|
| When scheduled, the id assigned to the SQL Server Agent I believe needs the permissions. Also When creating it, and lets say youwrite to a mapped drive letter, that same drive must be mapped on the server itself. When you manually run DTS it sees you as the clients mapping...when scheduled, it only sees the mappings to the server.Confused the hell out of me first time I used it(and subsequentley stopped using it)Brett8-) |
|
|
|
|
|
|
SQL Server DTS Scheduled Jobs