OnError event does not fire

• StillaLearner

  SSCrazy

  Points: 2636

  More actions

  December 18, 2007 at 6:56 pm

  #154024

  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

• Powichrowski Marek

  Hall of Fame

  Points: 3483

  More actions

  December 19, 2007 at 2:15 am

  #761310

  Is logging enabled for this package?

  Is onError enabled for this container?