none
notify operator task ssis

    Question

  • 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

    Wednesday, July 06, 2011 9:54 PM

Answers

All replies

  • The SMTP Task enables you to send emails. Is that not sufficient?
    http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me
    Jamie Thomson
    Wednesday, July 06, 2011 10:18 PM
    Moderator
  • Hi could you please elaborate me. 

     

     

    Thank you

    Wednesday, July 06, 2011 10:27 PM
  • 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
    Jamie Thomson
    Wednesday, July 06, 2011 10:27 PM
    Moderator
  • 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.

    Thursday, July 07, 2011 7:37 AM
  • @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
    Jamie Thomson
    Thursday, July 07, 2011 8:06 AM
    Moderator
  • 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 

    Thursday, July 07, 2011 10:32 AM
  • 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
    Jamie Thomson
    Thursday, July 07, 2011 10:40 AM
    Moderator