Hi All
wondering if someone can help - can't find any point in google about this problem.
I have created an SSIS package which contains a Sequence Container (SqC)
Inside this sequence container I have 4 Execute SQL Task (1,2,3 and 4). These sql tasks execute in parallel and the failure of anyone of these I expect to make the SqC go red (in debug mode) meaning it has failed.
For the SqC I have an OnError event. This consists of a Execute SQL Task task that logs the error packagename, sourcename, date, errornumber and error description into a central table in the database.
I also have a Send Email task to email should the OnError trigger.
I have tested this in a small package and it works.
Putting this into the larger package today (after adding the email facility) now does not work - ie the OnError event does not get fired. The db table does not get updated with the error and the email does not get sent.
Everything worked earlier in the week - when the email task was not defined yet. Now it does not.
I have tried taking away the email task - still does not work.
Anyone know why??
thanks