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!
"Drats! Foiled again!"