Win2k3 and DTS Folder access | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Win2k3 and DTS Folder access

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?
Rather try using local path as g:path 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? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>