SSIS Send Email On Error | Create, Attach and Send Mail Error Log File using Script Task

#SSISSendEmail #SendEmailScriptTask
Video Title : SSIS Send Email On Error | Create, Attach and Send Error Log File using Script Task
Video Link : • SSIS Send Email On Err...
Subscribe to my channel : / gurumatrix
How to send mails using script task : • SSIS Script Task Send ...
In this video we have demonstrated how to create error log file with error code, error description using script task and attaching same error log file in an email and send email using script task component. It is complete example using script task with c# code.
#SSISErrorSendEmail
#SendErrorEmail
#SSISErrorHandling
#SSISScriptTask

[@prasadbandi1995]

how to stop for each loop container?

[@Speakingmymind365]

what is the message in message body

[@kanikeveeresh4448]

Good morning sir.. I don't know about c# coding. However it is mandatory to learn in ssis..?

[@ericsos101]

Great video.. The value for my username and my password ? That’s where throw me off.. idk.. i get this error after everything was entered fine in the script task: Error: The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Authentication Required. Learn more at Task Send Email Using Script Task failed

[@gurunathad13]

Yes you need Gmail username and password if you are using Gmail SMTP, you can also use Outlook SMTP

[@ericsos101]

@@gurunathad13 when including my gmail and password into the value variables, that is that is the error i get:The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Authentication Required.

[@ericsos101]

@@gurunathad13 i solved the issue.. thx