SSIS主包无法完成 [英] SSIS master package cannot finish

问题描述

我将3个sql表导出到3个excels。 SSIS中的子包单独运行正常。我有3个执行包任务  的主包运行这些
3包。主包子包完成成功，但如果我查看子包的每个数据流，我可以看到它仍在运行。它们运行无限。

Im exporting 3 sql tables to 3 excels. Child packages alone in SSIS run OK. I have master package with 3execute package tasks where I run these 3 packages. Master package child packages finish successful, but if I look into each data flow of child packages I can see that are still running. And they run infinite.

包的结果是正确的，日志输出中没有错误，但这种无限运行的数据流令人困惑。 

Result of the package is correct, there is no error in log output, but this infinite running of data flow is confusing. 

任何想法为什么会发生这种情况？

Any ideas why is this happening?

主包：

子包控制流程：

child package control flow:

子包数据流：

child package data flow:

推荐答案

您好我能知道您的软件包正在构建的sql server版本吗？还可以吗？验证3个Excel工作表是否在for循环容器中运行？

hi will i be able to know the sql server version that your packages are building? and also can you verify the 3 excel sheets are running in a for loop container?

这篇关于SSIS主包无法完成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！