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 |
NorthernLights
Starting Member
4 Posts |
Posted - 2002-01-03 : 15:35:37
|
I moved my old DTS package to a new server and it now returns the following message "error opening datafile...". I can execute it manually without errors, but the scheduling fails. The owner of this package has sys admin rights, I am using UNC to connect to the file source. Has anyone run across this? |
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-03 : 15:59:21
|
Most likely SQLAgent Service account doesn't have the rights to the network share where the file is located. |
|
|
BMurray4321
Starting Member
4 Posts |
Posted - 2002-01-07 : 10:52:00
|
You may want to try adding a package user and a package password. Sometimes this helps bypass the SQL Agent rights |
|
|
|
|
|