One of my local DTS Packages is giving this error:

Error string: 'G:\FolderName1\FolderName2' is not a
valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on
which the file resides.

I've also tried the UNC path with the same error. The
scheduled package invokes the package under user sa.
I've created a user sa and mapped the path.

Any ideas on how to get this to run?

If the job is owned by the user sa then the job will run under the security
context of the SQL Server Agent Account

Have a read of this

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


--

----------------------------

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


"Mike" <michael.hendricks (AT) concrete (DOT) org> wrote