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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 DTS error

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.

Go to Top of Page

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

Go to Top of Page
   

- Advertisement -