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
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.
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