October 17, 2012 at 11:54 am
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!"October 17, 2012 at 2:53 pm
I figured out my problem! :w00t:
Dana
"Drats! Foiled again!"October 20, 2012 at 9:09 am
kindly share your solution........ i think logical OR should work fine.
October 22, 2012 at 9:15 am
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!"Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply