I have activex script in DTS , which sends mail using cdo.message object,
same type of script i used at ten different places to send reports,
recently from a week some scripts are failing to send mails, some are
successfully sending mails, I asked my nt admini to verify outbound queues
in exchange, but not trace of send to exchange server . I haven't changed my
script it is same , sometimes it fails sometimes it goes,i am really worried
what type of error is causing this, can someone help me out.

using windows 2000 advanced server(sp4)/sql server 2000 ent(sp3), all jobs
were scheduled.
The error message i am getting was pasted here.



DTSRun OnError: DTSStep_DTSActiveScriptTask_3, Error = -2147220482
(800403FE) Error string: Error Code: 0 Error Source= CDO.Message.1
Error Description: The transport failed to connect to the server.
Error on Line 45 Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context:
4500 Error Detail Records: Error: -2147220482 (800403FE);
Provider Error: 0 (0) Error string: Error Code: 0 Error Source=
CDO.Message.1 Error Description: The transport failed to connect to the
server. Error o. The step failed.