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

[@kanikeveeresh4448]

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

[@Speakingmymind365]

what is the message in message body

[@prasadbandi1995]

how to stop for each loop container?

[@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