View variables in SSIS during debugging

Question

I have a project in SSIS and I added an Execute SQL task that sends its result to a variable. I wanted to confirm the value because I was worried that he would try to write it as a resultet object, not an actual integer (in this case, I return COUNT).

My first thought was to run it in debug mode and add a global variable to the My Clock window. Unfortunately, when I right-click on the "Clock" window, the "Add Variable" option is grayed out. What am I missing here?

I realized that my variable is configured correctly, so I do not need methods, for example, insert a script in an MsgBox with a value or something like that. For future reference, I would like to see variables in debug mode. If there are any restrictions, I would like to know what and why all this, if someone knows.

Help is extremely inadequate in this, and every “tutorial” that I can find simply says: “Add a variable to the Clock window and debug it,” as if there should never be a problem with it.

Thank you for understanding!

Answer 1

I believe that you can add variables to the Clock window while the debugger is stopped at a breakpoint. If you set a breakpoint in a step, you should be able to enter variables in the Clock window when a breakpoint is hit. You can select the first blank line in the Clock window and enter a variable name (you may or may not get Intellisense there, I can’t remember how it works.)

Answer 2

Drag the variable from the Variables panel to Watch the panel and veil!

Answer 3

I know that this is a very old and, possibly, talk about an older version of Visual Studio, and therefore it may not be an option before, but in any case, my path would be when at the breakpoint use the locals window to see all the current variable values ​​(Debug -> Windows -> Locals)