May 22, 2009 at 11:00 am
I have an SSIS package that is a simple dataflow task. I have a mail task off the data flow task as a "failure" task to email me if the dataflow fails. The dataflow consists of a flat-file source to an OLEDB destination. If I delete the input file and run the package the dataflow task "fails" but never goes to the mail task. If I open the dataflow task the flat-file source is red and that's it. In the Progress window it says the flat-file source component failed in pre-execute.
Other than adding a step prior to the dataflow to check for the file and email if it is missing, is there a way to get the dataflow task to fail and just fall through to the failure mail task in the package?
May 22, 2009 at 1:43 pm
Do you have the FailPackageOnFailure property of the dataflow task set to false?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 24, 2009 at 6:18 am
How about creating an OnError event and placing the mail task here. This what I do to notify me when a package has failed.
May 26, 2009 at 6:04 am
Jack Corbett (5/22/2009)
Do you have the FailPackageOnFailure property of the dataflow task set to false?
Yep
May 26, 2009 at 6:05 am
andrew.roberts (5/24/2009)
How about creating an OnError event and placing the mail task here. This what I do to notify me when a package has failed.
We're looking at this but we were hoping there was a less code-intensive way...
May 26, 2009 at 6:19 am
That is the less code intensive way.
Click on Event Handlers then on the link that says 'Click here to create an 'OnError' event handler
Drag a send mail task onto the form
Configure the mail task
May 26, 2009 at 6:58 am
Can you tell in the event handler what the error is? It would be nice if I could include the error in the email text...
May 26, 2009 at 7:25 am
I haven't done this myself has I normally put a generic message in the e-mail. But just had a quick look give this a try and see how you get on.
Set the mail task up with a SMTP connection, a from and to email address.
Under Expressions click on the ellipses
Under property select MessageSource
Under the Expression click on the ellipses
From the variables drag in System::ErrorDescription
May 26, 2009 at 7:28 am
Thanks, will try that.
May 27, 2009 at 4:17 pm
I don't think that will work because if its failing in the pre-execute phase, then its not executing (logically), therefore there will be no event triggered because of the failure.
I'd add a script task that checks for the file, if the file does not exist, then change a boolean variable to false. Add another script task and set the result to value of the variable - from there, you can have your sendmail task.
May 28, 2009 at 5:34 am
niall.baird (5/27/2009)
I don't think that will work because if its failing in the pre-execute phase, then its not executing (logically), therefore there will be no event triggered because of the failure.I'd add a script task that checks for the file, if the file does not exist, then change a boolean variable to false. Add another script task and set the result to value of the variable - from there, you can have your sendmail task.
We added the OnError code just as a catch-all but we also added a script task before the DataFlow to check for the file. I knew I could do it that way, I was hoping there was a way to make the DataFlow task pass the failure on to the Mail task that was wired to it on a Failure precedent.
Viewing 11 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy