I have a DTS package (sql 2000 sp4) that executes correctly when I run it
from the DTS designer but fails when it is scheduled as a SQL Server Agent
job. My sql agent and sql server services both run under my Windows
account.

The failing step is an execute process task that calls a .bat file on a
network drive. The batch file does as follows

p:
cd \email\hold\decrypt\

java ..... [parameter string]

This step calls a java program that decrypts a file.

The error I get is "c:\program files\common files\system\msmapi\1033>p: The
system cannot find the drive specified."

I would think that this would work just fine as the sql agent job runs under
my windows account and the packages executes correctly when run via the DTS
Designer.

Can someone shed some light on this for me.

Many thanks!

Walter
waltmallon (AT) yahoo (DOT) com

The service account might be your account but that does not necessarily mean
the package will run as you.

Have a look here

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


--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Walter Mallon" <waltmallon (AT) yahoo (DOT) com> wrote

Thanks. I think the issue is that according to the knowlege base article
the sql server agent can't see mapped drived letters (which makes sense as
they are stored in my profile). I will have to use the net use command in
the batch file to map the drive. That may work.

Thanks again.

Walter


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

It can be flaky though as you are still using a mapped drive
and they are profile dependent, are not always that reliable
with service accounts. Try using a UNC path instead:
\\ServerName\ShareName\WhateverPath

-Sue

On Mon, 24 Apr 2006 11:28:18 -0400, "Walter Mallon"
<waltmallon (AT) yahoo (DOT) com> wrote: