sqlcurious
asked on
How to send email using SSIS package whenever there is failure in package execution
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
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
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.
ASKER
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
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.
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.
ASKER
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
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
ASKER
i have attached the screenshot of my package flow
packagescreenshot.docx
packagescreenshot.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.