Email task failure urgent

i use email task and it dosent send an email at all....this task causes an error..

If i need to set up email for the package if the package fails...

or how should i set in the sql server agent...iknow there is an option there but i dont know how to..

Please let me know...

Sureshv,

Please post the error.

|||

Here is the error

[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".

|||Did you create an appropriate SMTP connection to your mail server? When editing the Send Mail task you'll be able create an SMTP connection. Make sure the information is correct and that you have permissions to the SMTP server.|||

Here is what i did..

I droped the send mail task to my control flow.

then smtp connection :i typed in the ip address

from:i typed in some email address

to :i typed in my email address

message source type:variable(dont know just put int theses)

message ource User::Variable( " )

priority normal...

when i run i come of with this message.

please let me know if i am right

|||MessageSourceType is exactly what it says. The message of the e-mail is either directly input in the box below, or it is a variable that already has the message assigned to it, or it is contained in a file somewhere.

Try to make sure the IP address is really an SMTP server and that it is accepting anonymous connections:

In windows, Start->Run->cmd.exe

From there, "telnet your-ip-address-here 25"

If you get something to come up, then simply type "quit".|||

i checked as u asked me to " telnet your-ip-address-here 25" it was jus blank and the came up with c:\documents and settigs\my name>

Whats that 25 for?

|||

sureshv wrote:

i checked as u asked me to " telnet your-ip-address-here 25" it was jus blank and the came up with c:\documents and settigs\my name>

Whats that 25 for?

It should've done something. Some message should've shown up.

telnet 111.222.333.444 25

"25" indicates the port on the server. Port 25 is the SMTP port.|||thanks..how to set this to a group of people receiving email...i want to set this email only on error in the package how do i set this..|||how to send email only on failure?|||Use the red arrows in the control flow to hook up to a send mail task.|||

i wonder if there are read arrows to data flow,execute sql etc...

|||Sorry. When you connect (for instance) a data flow to a send mail task, the arrow will initially be green. Double click on the arrow and change the "Value" parameter from "Success" to "Failure."

Then the arrow will turn red.|||thanks|||

I have data flow (DB1 to DB2) task and then send mail task. The package executes everyday and mail notificate sent regularly. But if DB1 or DB2 connection failed (due to expired password or server not available or any network issues), the package failing in validation stage itself and send mail task never executed.

The expected result is, email must be sent with the result of data flow task.

Anyone comments please