SQL Server Performance Forum – Threads Archive
Win2k3 and DTS Folder accessWhen 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?
Rather try using local path as gath and make sure the SQLAgent has necessary privileges on the path specified in the active script. BTW which account is used to handle SQL services? _________