Hello all Im new bie to ssis and im trying to work on notify operator task to send an email about the count of rows loaded from excell. from some reason i were not able to undersatnd about notify operator task. can someone guide me through please cheers siva

The SMTP Task enables you to send emails. Is that not sufficient?http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Hi could you please elaborate me. Thank you

Hi could you please elaborate me. Thank you well, not really, no. Not unless you can elaborate on what you want to achieve. I have never heard of the Notify Operator Task. http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Hi, Why do you want to use Notify Task here ??? Instead you can go for "Send Mail Task", which is very easy to implement. check this link http://www.mssqltips.com/tip.asp?tip=1731 Let me know your requirement exactly. If you only need E-Mail notification then you can use "Send E-mail Task", in case of multiple notification then you should go "Notify Operator Task" @Jamie : Notify Operator Task is a part of Maintenance task in SSIS. MSDN SOURCE: By using the Notify Operator task, a package can notify one or more operators via e-mail, pager, or net send. Each operator can be notified by different methods. For example, OperatorA is notified by e-mail and pager, and OperatorB is notified by pager and net send. The operators who receive notifications from the task must be members of the OperatorNotify collection on the Notify Operator task.

@Jamie : Notify Operator Task is a part of Maintenance task in SSIS. Ah, I've never paid any attention to those things :)http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Hi I have configured send mail task like this, SMPT connection manager: Name: smpt connection1 server name: i tried with mail.gmail.com( could you tell me what i need to give here) it shows this error: [Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: The remote name could not be resolved: 'mail.gmail.com'". Could you please help me

If you want to use gmail as your SMTP server then you need to configure it with gmail's SMTP server address. According to How to use Gmail as your SMTP server it is smtp.gmail.com. http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me