SQL 2005 BreakPoints

  • Hi All,

    I am trying to set breakpoints on an Execute SQL Task which assigns a value to a variable based upon the query specified. Originally I checked the PostExecute breakpoint and set it to always so that I could see the value of the local variables. The task executes successfully and turns green, not breaking. I then literally check every breakpoint and even forced failure on the task to see if I could get it to break but still it is not. I haven't worked on a SSIS package in a couple of months but used it extensively in the past and do not remember any special configurations. Can anybody tell me what I am missing?

    Thank you in advance,

    Paul

  • Apparently it breaks when I run the whole package with the play button, but not when I right click and execute task. Did not realize that.

    Thank you all anyways.

Viewing 2 posts - 1 through 1 (of 1 total)

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