Error handling

• swetha.prachi

  Mr or Mrs. 500

  Points: 545

  More actions

  November 8, 2012 at 2:09 am

  #269974

  Hi all.

  We are handling the errors at the package level and inside the data flow task we have many lookups and if there is an error in the lookup or any transformation how do i fetch in which lookup transformation the error has occured.

  We are triggering the error mail in which we need to get the info in which lookup we got error pls helo me in this.

  Thanks in Advance

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  November 9, 2012 at 12:28 am

  #1557471

  I'm not sure this is possible.

  The name of the erroring component is not made available in the event handlers. Only the name of the dataflow is made available (System::TaskName).

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP