i am using the example from sqldts.com (link below).

but when i enter a unc path into the global variable and
the fso object function FolderExists returns a false.
There are no permissions issues.

http://www.sqldts.com/Default.aspx?246

"JI" <jidawgs (AT) hotmail (DOT) com> wrote in news:045201c3883b$f0483d60
$a301280a (AT) phx (DOT) gbl:

This works for me

Function Main()

dim fold
dim fso

set fso = CREATEOBJECT("Scripting.FilesystemObject")

msgbox fso.FolderExists("\\Myserver\My$\MyShare\")


Main = DTSTaskExecResult_Success
End Function


This also works

Function Main()

dim fold
dim fso

set fso = CREATEOBJECT("Scripting.FilesystemObject")

msgbox fso.FolderExists(DTSGlobalVariables("MyFolder").Va lue)


Main = DTSTaskExecResult_Success
End Function




--
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