Error description not shown in Event Viewer

• vibin.das

  Say Hey Kid

  Points: 705

  More actions

  July 27, 2010 at 11:13 pm

  #141241

  Hi All,

  I'm stuck on this issue for the one day.In my ssis package if any error occurs i'm using try and catch block.In the catch block i'm failing the SSIS

  Catch ex As Exception

  Dts.TaskResult = Dts.Results.Failure

  Dts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message.ToString(), String.Empty, 0)

  In the Event Viewer Error is shown for the application.But i'm not able to get the respective error description.It always shows description as "Package failed".Is there anyway where in i can get the error description in Event Viewer using the above statement.

  Please help it's urgent.

  Thanks,

  Vibindas

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 28, 2010 at 2:35 am

  #1199116

  You may find this post useful.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• PaVeRa22

  SSCommitted

  Points: 1965

  More actions

  July 28, 2010 at 12:09 pm

  #1199425

  Catch ex As Exception

  Dts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message.ToString(), String.Empty, 0)

  Dts.TaskResult = Dts.Results.Failure

  means, move failure line to end of statement i.e before end catch...