Re: can't find directory when package scheduled as job

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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx> wrote in message
news:eHzEP$6ZGHA.4060@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxx> wrote in message
news:et%23bm46ZGHA.4292@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxx







.

Relevant Pages

  • RE: DTS Package fails when Scheduled
    ... Make sure SQL Server Agent account has the correct rights/permissions. ... scheduled job under this context, I still received the error, even though I ...
    (microsoft.public.sqlserver.dts)
  • Re: Problems with SQL Srv. Agent and Proxy Account
    ... I have tried with both the sa account and with Use Windows ... Authentication on the SQL Server AGent Connection tab. ... >>rights recording to INF: Reset Proxy and the ...
    (microsoft.public.sqlserver.security)
  • Re: Problems with SQL Srv. Agent and Proxy Account
    ... You need to go to the General Tab of the SQL Server Agent ... >I have tried with both the sa account and with Use Windows ...
    (microsoft.public.sqlserver.security)
  • Re: HELP!! SQL Server Agent not working.
    ... Some things to check - Are you running SQL Server in fiber ... >changed the SQL SERVER SERVICE account to use a Local NT User account ... >configuration for SQL SERVER AGENT was also done in Enterprise Manager. ...
    (microsoft.public.sqlserver.security)
  • Re: cant find directory when package scheduled as job
    ... the batch file to map the drive. ... from the DTS designer but fails when it is scheduled as a SQL Server Agent ... This step calls a java program that decrypts a file. ...
    (microsoft.public.sqlserver.dts)