June 12, 2015 at 11:49 am
I have a simple SSIS package that imports an Excel Spreadsheet into a table. The column heading got changed, so the package failed, as expected, but I would like an alert or some way to make the scheduled job show "failed". I tried putting an event handler on the :Data Flow" step to send an email, but it didn't work.
I would like to figure out the event handler problem, but more important to have the job show as failed.
For some reason the Scheduled job shows "success" even though the SSIS package failed.
A better solution is to make the scheduled job itself fail, based on the package failing. Any tips ?
June 12, 2015 at 12:06 pm
homebrew01 (6/12/2015)
I have a simple SSIS package that imports an Excel Spreadsheet into a table. The column heading got changed, so the package failed, as expected, but I would like an alert or some way to make the scheduled job show "failed". I tried putting an event handler on the :Data Flow" step to send an email, but it didn't work.I would like to figure out the event handler problem, but more important to have the job show as failed.
For some reason the Scheduled job shows "success" even though the SSIS package failed.
A better solution is to make the scheduled job itself fail, based on the package failing. Any tips ?
If the failure inside the package does not cause the package to report a failure, then its like the result of one of two things. Either you disabled the failure notification via the some of the properties, or your the event handler is resulting in the package any more.
The simplest way to send out the email on the failure of the data flow, is to add an email task in the control flow. Connect it to the data flow using a precedence constraint set to work on failure. There's not need for any event handler just to send an email.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
June 12, 2015 at 12:14 pm
"The simplest way to send out the email on the failure of the data flow, is to add an email task in the control flow. Connect it to the data flow using a precedence constraint set to work on failure. There's not need for any event handler just to send an email. "
===============================
I tried that first, but it does not work for some reason. I did not get the email I was expecting.
I will take another look.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply