SSIS: Integration services: Throw error from Script Task (Error Handling)

There may be requirement to throw error from Script Task.
Here’s a way to Throw error from Script Task.

//Code Starts Here
Try
‘method which throws an error
Catch e
Me.ComponentMetadata.FireError(-1, “”, “Your Error Message: ” + e.Message, “”, true)
While Not e.InnerException Is Nothing
e = e.InnerException
Me.ComponentMetadata.FireError(-1, “”, “InnerException: ” + e.Message, “”, true)
End While
End Try
//Code Ends Here

For logging this error, Use below Code..

Dts.Events.FireError(-1, “”, “Your Error Message: ” + e.ToString(), “”, 0)

Here ToString() will fetch all the InnerException Messages.

Leave a Reply