Error handling for Script Task RRS feed

  • Question

  • I'm importing an Excel file and massaging it with a custom script task. I get an error "Index was outside the bounds of the array."  That error is helpful but I needed to know which of the 70,000+ lines the error occurred on. What is the best way of devbugging this issue? Try-Catch-Finally with messageboxes in the Catch clause?




    Thursday, September 21, 2006 7:14 PM


  • Assuming this is Script Task, not Script Dataflow Component, you can set a breakpoint at the beggining of the task, then use menu Debug > Exceptions, check the 'Thrown' box - this will make IDE stop when an exception is thrown by the Script Task.

    P.S. 70,000+ lines seems to be way too much for script task. You may find a custom task to be a better option for such undertaking.
    Thursday, September 21, 2006 7:35 PM