SSIS ForEach循环行为 [英] SSIS ForEach Loop behaviour

问题描述

这是典型的ForEach容器行为:

This is typical ForEach container behaviour:

但是，如果我执行下图所示的操作，则Execute SQL任务将永远不会执行，我该怎么做?如果某些其他类型的容器允许我执行此操作，则不必使用ForEach容器.

However, if I do whats shown in the image below, the Execute SQL task never executes, how can i do this behaviour? I do not have to use ForEach container if some other type of container will allow me to do this.

for每个循环本质上循环浏览文件夹中多个子目录中的文件.根据循环所在的文件夹，它会填充一个变量.从某些脚本"任务到任务a"和任务b"的连接器中使用此变量来确定将运行哪个任务.因此，如果在与任务关联的文件夹中检测到文件，则两个任务都可能运行.

The for each loop essentially loops through files in multiple subdirectories in a folder. Based on which folder the loop is in, it populates a variable. this variable is used in the connectors from "some script" task to "task a" and "task b" to decide which task will run. So it is possible that both tasks will run if files are detected in the folders associated with the tasks.

我真正需要的是任务a和b在完成后都转到同一个数据库任务.

What I really need is for both task a and b to go to the same database task upon completion.

推荐答案

原来是解决方案:

这篇关于SSIS ForEach循环行为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！