How to Stop Script Component Exceution when Catch block catches an error.

Question

Hi All,

I am using Script Component in my DFT and its returnuing an exception. I have to stop the package execution when Exception raises. Please suggest.

Thanks in advance

Regards

Ram

---

Ram MSBI Developer

Answer 1

You can use FIRE Error in Catch block

something like

Try

'' Your code

Catch e

'' Your catch handling code here

Me.ComponentMetadata.FireError(-1, "", "ErrorOccured: " + e.Message, "", true)

End Try

---

Hope that helps ... Kunal

Answer 2

Select your DataFlawTask and in the properties window set "FailPackageOnFailure" property to True. What this does is that if the data flow task (with the script component) fails for any reason it will fail the entire package and stop execution.

---

http://btsbee.wordpress.com/

Answer 3

any luck with the solution ??

---

Hope that helps ... Kunal

Answer 4

Thank you very much. This solution is working fine.

Regards

Ram

---

Ram MSBI Developer

Answer 5

Can you please mention the your script to be used in C# ssis script component.

Me.ComponentMetadata.FireError(-1, "", "ErrorOccured: " + e.Message, "", true)