Please start any new threads on our new site at 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 

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?

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

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 -