循环内的脚本。第二次执行时出错 [英] Script inside a loop. error during 2nd execution
问题描述
我有一个在循环中运行脚本任务的包。
I have a package that runs a script task inside a loop.
public void Main()
{
                  int intCount;
                  intCount =(int)Dts.Variables [" User :: Count"]。Value;
public void Main()
{
int intCount;
intCount = (int)Dts.Variables["User::Count"].Value;
//某些逻辑
//some logic
< span style ="font-size:0.75em"> &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; Dts.TaskResult =(int)ScriptResults.Success;
}
在第一次迭代期间,代码运行正常。在后续执行期间,如果我尝试在即时窗口中查找任何变量的值或快速查看
During the first iteration code works fine. during subsequent execution I get the below error if I try lookup the value of any variable in immediate window or quick watch
推荐答案
嗨 Gowthammanoharan,
Hi Gowthammanoharan,
我不确定SSIS项目是否支持即时窗口 。
I'm not sure if SSIS Project supports immediate window .
在SSIS中,您可以在"脚本任务"上设置断点,并在"本地窗口"中检查变量运行时值。
In SSIS, you can set breakpoints on the Script Task, and check the variables runtime value in the Locals Window.
请参阅
这篇关于循环内的脚本。第二次执行时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!