Display Exception Message in SSIS Script Task

Question

Here when task is failed in Script Task, I always get a result as "Error: The script returned a failure result" in the Progress/Execution Result Tab, which I am unable to identify what error had occurred. Inside the script task, I have given the code for failed result, as shown :

Dts.TaskResult = (int)ScriptResults.Failure;

How will I identify what error had occurred inside the Script Task ? What should I apply inside the code ?

Answer 1

You can debug the script task by just setting a breakpoint in the code.

If you want you can also use MsgBox to show the error details but a logging solution would be more elegant one ( Dts.Log ).