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
    Moderator
    SQL-Server-Performance.Com

Share This Page