Error description not shown in Event Viewer

  • 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

  • You may find this post useful.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • 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...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply