Win2k3 and DTS Folder access

[skeezwiz]

When running a scheduled job from sql srv 2000 on win2k3, I get a "path not found" error msg in my Activex script task (I'm using Scripting.FileSystemObject).

Its a UNC path name and everyone has folder access and folder exists.

I even mapped the drive and referenced it that way and still no path found.

Tried starting server and agent using different accounts (domain & local) and still saying path not found.

Any ideas?

 

[Kolt]

and if the folder is locally on the server does it work? if does then it's probably security politics problem

 

[skeezwiz]

When folder or file is local then its no problem.

The only way that I can get a job to be sheduled is if the owner is "win2k3Name\Administrator".

But if the package is referencing folder and files on a remote machine then I get error msg.

I even added the remote machine as a trusted site on win2k3 and I still get error msg.