Scheduled Job Fails

[BJ]

The code runs ok as in the DTS designer but fails when I
run it as a job. It gives the following error:

DTSRun OnStart: DTSStep_DTSActiveScriptTask_1

DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -
2147220421 (8004043B)

Error string: The task reported failure on execution.

Error source: Microsoft Data Transformation Services
(DTS) Package

Help file: sqldts80.hlp

Help context: 1100



Error Detail Records:



Error: -2147220421 (8004043B); Provider Error: 0 (0)

Error string: The task reported failure on execution.

Error source: Microsoft Data Transformation Services
(DTS) Package

Help file: sqldts80.hlp

Help context: 1100



DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1

DTSRun OnStart: DTSStep_DTSSendMailTask_1

DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -
2147220352 (80040480)

Error string: Logon failed: Unable to get the default
MAPI Message Store due to MAPI error 273: The information
store could not be opened.

Error source: Microsoft Data Transformation Services
(DTS) Package

Help file: sqldts80.hlp

Help context: 9100



Error Detail Records:



Error: -2147220352 (80040480); Provider Error: 0 (0)

Error string: Logon failed: Unable to get the default
MAPI Message Store due to MAPI error 273: The information
store could not be opened.

Error source: Microsoft Data Transformation Services
(DTS) Package

Help file: sqldts80.hlp

Help context: 9100



DTSRun OnFinish: DTSStep_DTSSendMailTask_1

DTSRun: Package execution complete.