cant step into script task as breakpoint in Main is never hit

  • I have a breakpoint right inside my Main method in a script task in SSIS. I need to debug the code in the script task. Unforutnately the breakpoint right inside the Main method is never hit. I dont know why.

    If i declare a variable right outside the main method, it is hit, but the flow jsut doesnt go into the Main. In the script properties, Main is specified as the starting point for the script.

    Im not sure what to do next. any advice?

  • ok, ive remedied this on my local machine by DelayValidation flag to True. The issue is still happening on one of my remote servers though.

  • Are you saying that you are getting an error before the script task even executes and that that is why your breakpoint is not being hit?

    It would help if you post the full text of the error.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • there is no error. heres what happens(on my remote server)

    I have a project with one script task.

    I have a breakpoint right inside the main method of the script task.

    I click the play button. on clicking this, the package should execute and execution should stop at the breakpoint.

    The code window opens, but no code shows, and then the script task goes green, shoeing it has finished. I have not been able to walk through the code as it didnt stop at the breakpoint.

    On my desktop, the execution stops at the breakpoint and i can step through the code.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply