InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 23:32:18 GMT20http://www.sqlservercentral.com/Forums/Topic959828-148-1.aspxCatch ex As ExceptionDts.Events.FireError(1, ex.TargetSite.ToString(), ex.Message.ToString(), String.Empty, 0)Dts.TaskResult = Dts.Results.Failuremeans, move failure line to end of statement i.e before end catch...Wed, 28 Jul 2010 12:09:24 GMTPaVeRa22http://www.sqlservercentral.com/Forums/Topic959828-148-1.aspxYou may find [url=http://msdn.microsoft.com/en-us/library/ms186244.aspx]this post[/url] useful.Wed, 28 Jul 2010 02:35:50 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic959828-148-1.aspxHi 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 SSISCatch 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,VibindasTue, 27 Jul 2010 23:13:50 GMTvibin.das