I am using this task to report errors to admin.In our production enviroment
,there is no Exchange server or everything else.What is this task using for
sending emails? Do I have to configure things in production server?


Thanks

I'm actually answering myseld for other people's reference.

Hi Ray5531,

It's actually a good question.The existing Send Mail Task in DTS is based on
Messaging Application Programming Interface(MAPI) which means that we need
to install Outlook or any other MAPI compliant product or at least the
production server needs to have Microsoft messaging API (MAPI) installed
with a valid user profile.

If there is nothing like above in your production server then we need to
write our own send mail tasks which uses SMTP server which only handles the
ongoing requests OR YOU CAN USE one o those SMTP task which are already
written for you.one is here:
http://www.sqldev.net/dts/SMTPTask.htm


HTH ;-)

Ray5531 (No-MVP ,No-MCP,nothing:-))