Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS failure constraints Expand / Collapse
Author
Message
Posted Wednesday, October 17, 2012 11:54 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 18, 2013 4:48 PM
Points: 46, Visits: 113
hello all...
i have created an SSIS package which works beautifully until i come to the final task, which is sending an email when any process fails.

i have 2 sequence containers named TIP and NOTIP and they are connected by a success constraint. the failure constraint for each sequence connects to a send email task. i am forcing an error in one of the container tasks to test the email task, but after the container task fails the process stops instead of executing the email task. i can't figure out why and i'm now going in circles. also please note:
* each task within the sequence is set to True for FailParentOnFailure
* the constraint from the sequence to the email task is set to False for LogicalAnd - my understanding if LogicalAnd is True the process will wait for all tasks in the sequence to fail before executing the email task.

i would appreciate any help...thanks so much!


Dana

"Drats! Foiled again!"
Post #1373977
Posted Wednesday, October 17, 2012 2:53 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 18, 2013 4:48 PM
Points: 46, Visits: 113
I figured out my problem!

Dana

"Drats! Foiled again!"
Post #1374062
Posted Saturday, October 20, 2012 9:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 1:28 AM
Points: 22, Visits: 122
kindly share your solution........ i think logical OR should work fine.
Post #1375108
Posted Monday, October 22, 2012 9:15 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 18, 2013 4:48 PM
Points: 46, Visits: 113
i was having 'one of those days'! in testing i was executing the sequence container only, but the email function was outside of that container. it was a true head banger when i realized it! once i executed the entire package everything worked. and yes, OR worked just fine.

Dana

"Drats! Foiled again!"
Post #1375500
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse