?
Solved

How to send email using SSIS package whenever there is failure in package execution

Posted on 2011-03-22
6
Medium Priority
?
1,591 Views
Last Modified: 2012-06-27
Hi experts ....need help
I have a case scenario

When a package fails, I must immediately send email messages that identify the task that failed and describe the error in detail.

how to build package in SSIS
need details steps plus some screenshots if possible
0
Comment
Question by:sqlcurious
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:jimtpowers
ID: 35192611
Assuming you will run the SSIS package as an agent job, setup the job to email you when the job execution fails. The log from the job will tell you where it failed.
0
 

Author Comment

by:sqlcurious
ID: 35192755

thanks for your reply


Is there any way that i can do it using the event handler in SSIS  and creating the flow? what could be the steps and waht different tasks i need to use and how
0
 
LVL 4

Expert Comment

by:jimtpowers
ID: 35192885
When you have your "successfull" flow developed, you'll notice when you click on a control flow object, another green arrow shows up. Link that to your send mail task then right-click it and select failure. Then, drag the green arrow from the send mail task and link that to the next task in your original flow.

This is just book knowledge. I have not actually done this since I rely on the logs to tell me where my SSIS package failed. Example
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:sqlcurious
ID: 35193113
hi expert

 
This is my first time in creating ssis package and doing error handling
how to setup to run ssis package to run as an agent job

As per your first suggestion how to setup the job to email me ,when the job execution fails.The project req is----- even if the package execution fails for particular task,the package should run for the remaining tasks and should send  en email where the execution failed.

please provide me in detail


0
 

Author Comment

by:sqlcurious
ID: 35193132
i have attached the screenshot of my package flow
packagescreenshot.docx
0
 
LVL 4

Accepted Solution

by:
jimtpowers earned 2000 total points
ID: 35193222
I just found another article you may want to take a look at. This author does a little more than I get the impression you are looking to do but should give you all of the detail you are looking for.

Handling Errors in SSIS
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question