SSIS Tutorial Part 85-Send Error Email with Error Code, Error Description by using Send Mail Task
Вставка
- Опубліковано 17 лис 2024
- SSIS Video Scenario:
We have created an SSIS Package, that fails sometime. The only way to find out if the Package is failed to check SQL Server Job history or alerts generated by SQL Server Agent Job. We want to include components in SSIS Package so we can send an Email from SSIS Package with Error Information when the Package fail.
Solution:
In this video we will find out the solution for above scenario, we will learn below items in this Video
How to create SSIS Package Parameters
How to use Event Handlers in SSIS Package for OnError Events
How to Create error in SSIS Package for Test Purpose
How to use Send Mail Task in Event Handler to send email with Error Code, Error Description etc.
Link to the script used in the video " How to send Error email from SSIS Package"
sqlage.blogspot...
To follow Step by Step SQL Server Integration Services(SSIS) Video Tutorial By TechBrothers, please open below link.
www.techbrother...
THank you so much, Dhanyavaad, from EL Salvador, between Mexico and Colombia
Thank you for taking the time to do these videos. While they may not be perfect, they help others to learn and server as a good reference. Let those that have only negative things to say create and post videos if they see something they can improve.
Thanks dear.
I agree...the resource you are providing is invaluable.....kuddos to you and ignore the haters, they are just that haters!
Great explanation, thank you very much. Exactly what I was after!
thank you so much , first time I see someone so disappointed that his task has suceeded ! :D
Great job
Hi AAmir.. thanks for making all this knowledgable videos..
but couldn't find the link for Creating "SMPT SERVER".
You are very welcome. please check this link. www.techbrothersit.com/2015/03/how-to-configure-dbmail-in-sql-server.html
Great, you just saved me many hours of trial and error.
Glad to hear that my effort was useful.
That's what I was looking for, I'm going to use this solution with Visual Studio 2015 and hope it's gonna work. Really THANK U for your time and job :)
You are welcome. hopefully will work for you. Thanks for watching.
Thank you for the video. Can to just create variables instead of parameters, if so then which is preferable
thank you so much well taught
Great Sir,I had One Querry Is it possible to download files from unread mails using script task,If yes please help me with the code sir
Thanks for the video. Does anyone know how to trigger error handling after an error on validation phase? Because on error, an email is sent but if it is a validation error, there is no email.
Great job
I configured this set up in my package but it triggered multiple mail when Data flow task fail
Please let me know Do I need any other configuration to avoid
very great and detail explanation, thank you so much.
Awesome. Thanks for the detailed explanation.
You are welcome. Thanks for watching.
Thanks a lot from Brazil!
Mail Configure in DB but not working in SSIS send mail task
Thank you so much! It help me a lot!
you are the best!
Hi Aamir,
I saw two emails were sent out. one with row skipping and another with actual error message. So my question is how can we avoid multiple email not being sent out.
Hi Darpan,
please check this link www.techbrothersit.com/2014/09/ssis-how-to-handle-multiple-emails-from.html
sorry for late reply.
@@TechBrothersIT Can you please upload images to the link you shared above. Thank you.
sir how to use smtp in ssis , i managed to send email through ssms but in ssis it is kept failing , I supplied "smtp.gmail.com" as server name in mail task smtp connection but still failing with error "Error: 0xC00291C4 at Send Mail Task, Send Mail Task: The Simple Mail Transfer Protocol (SMTP) server is not specified. Provide a valid name or IP address of the SMTP server." any suggestions ???
I have the same problem. Can you include your link on how to configure the SMTP server? Thanks
sir jee two votes for the same video , please kindly add this video to your portal.
Hi guys, I see that we missed that video, we will add the video how to setup SMTP. We are really busy now a days and can't promise when. will do our best. In real time scenarios, you guys will not be setting up the SMTP by using google or hotmail, it will be already setup. You can skip the setup and just get the idea how Send Mail task works. Thanks for leaving the comments, will try!
thank you for reply sir
I would be grateful. Thank you for the response.
Gr8 video
funny! I like it!
and stop saying "a" after every word :D
If you do not have any idea what is going on when you are making a video, stop wasting others time
+Karan Salekar you need to build a learning attitude brother, these tutorials are doing a great deal of help to others.
Karan why are you posting these messages , what is that u r getting
+Karan Salekar .....Dude are you for real. Instead of thanking TechbrothersIT for valuable information , you are criticizing him ....If you don't like it...don't watch...simple. No need to bring other person down with your attitude.