Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2012-02-03 : 10:46:59
|
| I have a package that calls multiple Execute Package tasks.I am trying to send an email when any of these package calls fail.I cant get this to work and was thinking of adding a script task that would capture if any of the tasks failed.Does anyone know the C# syntax needed to capture the pass or fail results of a specific Execute Package task?ThanksQ |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-03 : 10:58:54
|
| why?how have you currently set send mail taskas per your scenario you should be setting it in onerror event of the execute package taskalso set failpackageonfailure property to false for it so that loop continues with next package------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2012-02-03 : 11:53:12
|
| Error handlers did the trick.... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-03 : 11:57:45
|
| ok..cool...thats the way to go------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Capture when Execute Package Task passed/failed