DTS Package Error

Hi,

I have a DTS Package which creates a text file and then sends that file as an attachment in email using "send mail task".

I can run this package manually but if I schedule this package, its getting failed. Here is the error message

"DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSSendMailTask_1 DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 DTSRun OnFinish: DTSStep_DTSSendMailTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed."

Could you please help me with this issue? I am using SQL Server 2000.

Thanks!Have you enabled the ability to send mail ?|||I enabled mail, but now I am getting different error message

"DTSStep_DTSSendMailTask_2, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) P. The step failed."

Thanks!|||Is sql server agent running ? And have you setup the mail profile within the agent ?

DTS Package

Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
NirajHow do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegroups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>|||I launch the dts package by sql server agent|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegroups.com...
>I launch the dts package by sql server agent
>

DTS Package

Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
Niraj
How do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegr oups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>
|||I launch the dts package by sql server agent
|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegr oups.com...
>I launch the dts package by sql server agent
>

DTS Package

Hi,
I want to write a stored procedure that queries the DTS packages
currently running and sends email to user if anyone of them fails. I
want to know how we can know status of any DTS from stored procedure.
Thanks,
NirajHow do you launch the DTS Package? Manual or by SQL Server Agent?
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129807126.770730.251640@.f14g2000cwb.googlegroups.com...
> Hi,
> I want to write a stored procedure that queries the DTS packages
> currently running and sends email to user if anyone of them fails. I
> want to know how we can know status of any DTS from stored procedure.
> Thanks,
> Niraj
>|||I launch the dts package by sql server agent|||Ok, write a two additional steps (one for a failrure and second for a
success) which will send you email if the step was complete or it wasn't
Make a step as on success action got to the step (success)
and on failure action go to step (failure)
"nirajshah" <niraj.shah@.travelex.com> wrote in message
news:1129813759.640710.278460@.o13g2000cwo.googlegroups.com...
>I launch the dts package by sql server agent
>