I'm trying to run this activex script from a DTS package:

option Explicit

Function Main()

Dim oFS

Dim vFileList

Set oFS = CreateObject ("Scripting.Filesystemobject")

Dim sPath

Dim oFiles

sPath ="\\<ip-adress>\Folder\"

set oFiles = oFS.GetFolder (sPath)

set oFS = Nothing

Main = DTSTaskExecResult_Success

End Function



The path I refer to is on another domain then the machine that runs the DTS.
When I run this locally (which is also on another domain) it runs without
problems, but when it's being run by the SQL server agent on the SQL server
it fails due to user rights ("error: Path not found").

I have tried to map the drive it is trying to contact on the SQL server
while logged on as SQL server agent, but without any luck.

Have a look at this

http://support.microsoft.com/?kbid=269074

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"fredrik" <fredrik.hagelund (AT) dmhuset (DOT) no> wrote