All of the others code should be put in a Try block. The Catch block at a minimum should contain the statement:

Dts.TaskResult = Dts.Results.Failure