Error description not shown in Event Viewer

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Error description not shown in Event Viewer

Error description not shown in Event Viewer

Rate Topic

Display Mode

Topic Options

Author

Message

vibin.das

Posted Tuesday, July 27, 2010 11:13 PM

SSC 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

Adiga

Posted Wednesday, July 28, 2010 2:35 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 3:50 AM
Points: 1,618, Visits: 20,898

You may find this post useful.

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Post #959891

PaVeRa22

Posted Wednesday, July 28, 2010 12:09 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, November 02, 2010 8:28 PM
Points: 73, Visits: 180

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 »

Permissions