I have a classic one. Never the less I cannot get around.

When I run package, it executes fine loading file from specified location.
Schedule job fails when tries to run that package reporting ‘Error string:
Error opening datafile: Access is denied’

Facts:

Path indicating file does not use map letter (i.e. G:\SomeDir\.file.txt). It
uses UNC (i.e. \\SrvName\SomeDir\file.txt)

Should not be any restriction accessing that path.

I don’t have server administrator rights.

Help greatly appreciated!

Does the SQL Agent service account have access to the file?
And if the file is on another server, the SQL Agent service
account needs to be a domain account, not running under
Local System.

-Sue

On Mon, 19 Dec 2005 08:05:03 -0800, "User026"
<User026 (AT) discussions (DOT) microsoft.com> wrote:

"User026" wrote:

access rights issues could be at a source conn, in activex conn stmt, in a
folder pulling data from, in a destination conn, etc.
Check ALL conn stmts and anywhere the package has to connect to any other
source. I've had them fail with no rights to copy data to a spreadsheet in a
folder on a network drive.....