Handling SSIS Event handlers (Urgent help)

• sabarichandru

  SSCommitted

  Points: 1704

  More actions

  December 11, 2008 at 3:31 am

  #125748

  Dear all,

  i'm new to SSIS Event handlers . i created a package with 1 OLEDB Source continue with 3 lookup then finally with 1 OLEDB Destination .

  i have attached screen shot for reference . in that transformation i got error in Lookup due to Mismatch record .i handled in Redirect Row .

  but now they ask me to handle in Event handler . so i need suggestions that how to capture the particular mismatch error in event handler .

  anybody help me out to sort this Error .. ASAP .

  Thanks in Advance!

  Regards,

  Sabari.C

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  December 11, 2008 at 5:50 am

  #910990

  Are you supposed to do something with the records, or just log an error somewhere? Should the package fail, or continue?

• beena.33

  Valued Member

  Points: 59

  More actions

  December 12, 2008 at 5:49 am

  #911585

  try writing a script component and place it on the Event Handlers OnError event.