Call HandleError

• abdulkboy

  SSC Veteran

  Points: 212

  More actions

  January 19, 2009 at 6:39 pm

  #128060

  Hi Gurus,

  I have a following code in ActiveX in a DTS Package (ActiveX Task)

  If Err.Number <> 0 Then

  Call HandleError ("Error ","DB: " & SQL)

  End If

  and I'm trying to convert it to VB.Net. I don't know how to convert it or where to find it in DTS Package HandleError routine.

  I would appreciate any help.

  Thanks

• Mukti

  SSCrazy

  Points: 2826

  More actions

  January 20, 2009 at 12:10 pm

  #929884

  You can set the task result to failure and

  Dts.TaskResult = Dts.Results.Failure

  Then add Onerror event handler from the Event Handler tab in BIDS.

  This might be helpful info for you

  http://techyfreak.blogspot.com/2007/08/exception-handling-in-ssis-script-task.html