Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error description not shown in Event Viewer Expand / Collapse
Author
Message
Posted Tuesday, July 27, 2010 11:13 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 22, 2010 3:02 AM
Points: 31, Visits: 116
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

Post #959828
Posted Wednesday, July 28, 2010 2:35 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 1, 2014 6:18 AM
Points: 1,618, Visits: 20,980
You may find this post useful.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Post #959891
Posted Wednesday, July 28, 2010 12:09 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:47 PM
Points: 73, Visits: 184
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...
Post #960270
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse