SQL Server Performance

Win2k3 and DTS Folder access

Discussion in 'SQL Server DTS-Related Questions' started by skeezwiz, Aug 25, 2003.

  1. skeezwiz New Member

    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?
  2. satya Moderator

    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

Share This Page