在调试期间观察 SSIS 中的变量 [英] Watching variables in SSIS during debug

问题描述

我在 SSIS 中有一个项目，并且我添加了一个执行 SQL 任务，该任务将其结果发送到一个变量.我想确认该值，因为我担心它会尝试将其作为结果集对象而不是实际整数写出(在这种情况下，我将返回一个 COUNT).

I have a project in SSIS and I've added an Execute SQL Task which sends its result out to a variable. I wanted to confirm the value because I was worried that it would try to write it out as a resultset object rather than an actual integer (in this case I'm returning a COUNT).

我的第一个想法是在调试模式下运行它并将全局变量添加到我的观察窗口.不幸的是，当我右键单击 Watch 窗口时，添加变量"选项是灰色的.我在这里错过了什么?

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

我已经确认我的变量设置正确，所以我对诸如将脚本放入带有值的 MsgBox 或类似内容的方法不感兴趣.为了将来参考，我希望能够在调试模式下观察变量.如果对此有某种限制，那么如果有人知道，我想知道这一切的原因和原因.

I've gotten around confirming that my variable is set correctly, so I'm not interested in methods like putting a script in to do a MsgBox with the value or anything like that. For future reference I'd like to be able to watch variables in debug mode. If there are some kind of constraints on that then I'd like to know the what and why of it all if anyone knows.

这个帮助严重不足，我能找到的每一个教程"都只是说将变量添加到观察窗口并进行调试"，好像这样做永远不会有问题.

The help is woefully inadequate on this one and every "tutorial" that I can find just says, "Add the variable to the Watch window and debug" as though there should never be a problem doing that.

感谢您的任何见解！

推荐答案

我相信您只能在调试器在断点处停止时向 Watch 窗口添加变量.如果在步骤上设置断点，则应该能够在遇到断点时在 Watch 窗口中输入变量.您可以在 Watch 窗口中选择第一个空行并输入变量名称(您可能会也可能不会在那里获得一些智能感知，我不记得它的效果如何.)

I believe you can only add variables to the Watch window while the debugger is stopped on a breakpoint. If you set a breakpoint on a step, you should be able to enter variables into the Watch window when the breakpoint is hit. You can select the first empty row in the Watch window and enter the variable name (you may or may not get some Intellisense there, I can't remember how well that works.)

这篇关于在调试期间观察 SSIS 中的变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！