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