为什么我在Foreach循环编辑器中看不到ADO枚举器配置集合 [英] Why can I not see ADO Enumerator configuration Collection in Foreach Loop Editor

问题描述

我试图在执行SQL语句后执行Foreach循环。我在控制流上添加了一个执行SQL任务。我创建了项目级变量，一个数据类型为Object，Value = System.Object，另一个数据类型为String，值为。

我已将SQL任务配置为返回a完整的结果集，并将其连接到控制流上的Foreach循环容器。我在Foreach循环容器中添加了一个数据流任务。编辑Foreach循环容器时，集合选项卡不显示ADO枚举器。我从这个网站下载了一个样本：http：//www.timmitchell.net/post/2013/05/28/using-the-ssis-object-variable-as-a-result-set-enumerator/

当我打开那个样本时，我会看到ADO集合。我试图像我的样本一样设置我的包，但无论我做什么，收集选项卡都不允许我做任何更改。



执行SQL有以下SQL语句：

SELECT distinct MoveID

FROM [dbo]。[ ccRateEstimates]

WHERE [Print_Flag]！='Y'



如果有更多信息可以帮助我找到答案，请告诉我。

任何帮助都会非常感激！



谢谢，



沙龙

I am trying to Execute a Foreach Loop after a Execute SQL statement. I have added an Execute SQL task on the control flow. I have created to project level variables, one with a data type of Object, Value = System.Object, and the other data type String, Value "".
I have configured the SQL task to Return a full result set, and conntected it to a Foreach Loop container on the Control Flow. I have added a Data Flow task inside the Foreach Loop container. When I edit the Foreach Loop container, the collection tab does not display the ADO Enumerator. I downloaded a sample from this web site: http://www.timmitchell.net/post/2013/05/28/using-the-ssis-object-variable-as-a-result-set-enumerator/
When I open that sample, I DO see the ADO collection. I have tried to set my package like this sample, but no matter what I do, the collection tab does not let me make any changes.

The Execute SQL has the following SQL statement:
SELECT distinct MoveID
FROM [dbo].[ccRateEstimates]
WHERE [Print_Flag] != 'Y'

Please let me know if more information would help get an answer.
ANY help would be GREATLY appreciated!

Thanks,

Sharon

推荐答案

这篇关于为什么我在Foreach循环编辑器中看不到ADO枚举器配置集合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！