Dear Experts,
I have a foreach loop in my SSIS package.
In this loop there are many Data Flow, Execute SQL tasks, Execute Process Tasks and Script Tasks.
The Loop is running properly.
Now I want to add the error handling.
Remark: I'm very new to SSIS...
The first thing I did was: adding an Error handler saying "On Error" send a mail.
But when trying, as the error was thrown, the execution stopped, and no mail was sent.
I would like to have, that the execution of the current cycle stops.. a mail is sent and then the loop goes on with the next cycle.
Now my question:
how can I do this.
or in general... how can I do the errorhandling in SSIS the best
Thanks a lot!
Start Free Trial
