InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 12:21:58 GMT20http://www.sqlservercentral.com/Forums/Topic1373977-1292-1.aspxi 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.Mon, 22 Oct 2012 09:15:46 GMTdanawexlerhttp://www.sqlservercentral.com/Forums/Topic1373977-1292-1.aspxkindly share your solution........ i think logical OR should work fine.Sat, 20 Oct 2012 09:09:38 GMTpieceskoolhttp://www.sqlservercentral.com/Forums/Topic1373977-1292-1.aspxI figured out my problem! :w00t:Wed, 17 Oct 2012 14:53:31 GMTdanawexlerhttp://www.sqlservercentral.com/Forums/Topic1373977-1292-1.aspxhello 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!Wed, 17 Oct 2012 11:54:03 GMTdanawexler