SSIS Send Mail Task Example | Send Mail Task OnError Event Handler

[@SomeOne-uy4kj]

Is there a way in SSIS to call a proper profile/account- that already works via SSMS (eg Send Test Email) -to a package? My objective is to use the Google APP password in the profile/account that I have set up, as I am getting authentication errors via SSIS that probably were not in play when you released this video. Put simply, Google change their policy about six months, ago.

[@RAJESHKUMAR-wf8ol]

Hii sir Your explanation is very good but u can upload the ssis packages step by step that's better sir and every person has understanding

[@gurunathad13]

Ok sure ...but how to upload files on KZbin ?...Any alternative way can I share it

[@saket6]

Explanation is very good and excellent but inserting a log using insert statement is not right. You can use package's logging option which will load errors into dbo.sysssislog table that can be used to produce structured error log file to attach to the mail. This is the easiest way than creating a custom error log table and inserting errors. one advantage with custom error log table is the table can be dedicated a particular SSIS project where as dbo.sysssislog is meant for all SSIS projects/packages which are logging errors into a the database. This is just for your information.

[@gurunathad13]

Yes true...we can create logging 👍

[@saket6]

@@gurunathad13 one more information. If you use send mail task in error event at package level, it will send multiple mails based on number of tasks in the package. It is practical issue. To stop mail task to send multiple mails, you need to use for loop container and inside container you need to use send mail task. Search about this isdue in Google, so that you will come to know.

[@gurunathad13]

@@saket6 sure will check that too ...thank you 👍

[@deshubhammishra]

how to configure smtp server in local

[@gurunathad13]

We can't configure local SMTP Server. For this we need proper IP and Email Server to Authenticate with smtp user name and password