SSIS数据流任务挂起 [英] SSIS Data Flow Task hanging

问题描述

我正在忙着运行一个从大量mariaDB中引入数据的包。我用SSIS构建了这个包，它运行了好几个月。上周五，该软件包开始挂起其中一个数据流。它通常挂在
数据流中的一个（第一个），但偶尔挂在另一个上。它并不总是挂在每个流程中的同一个表中，如果你继续尝试运行它，它最终会起作用。为了测试这个问题，我选择了一个经常挂起的表，并创建了一个包来加载
表。有时它会挂起，有时会起作用。当它挂起时，它并不总是挂在同一点上。表中的数据似乎不是问题，但可能存在我遗漏的内容。 

I am busy running a package that brings in data from a number of mariaDBs. I built the package with SSIS and it has been running fine for a few months. Last week Friday the package started hanging on one of the Data flows. It normally hangs on one of the data flows (the first) but occasionally hangs on another. It doesn't always hang on the same table in each flow and if you keep trying to run it, it eventually works. To test the issue I picked one table that it hangs on often and created a package to load that table. Sometimes it hangs and sometimes it works. When it hangs it doesn't always hang at the same point. The data in the table doesn't appear to be an issue but there may be something that I am missing. 

日志记录中没有错误消息（参见下文）。 Visual Studio中调试的输出声明："SSIS包[path]已完成：已取消"。有没有人对我如何解决这个问题有任何想法？

There is no error message in the logging (See below). The output from the debugging in visual studio states: "SSIS package [path] finished: Canceled". Does anyone have any ideas as to how I can fix this?

尝试：

更改交易从需要到支持

更改验证外部元数据为false

Change validate external metadata to false

在visual studio和SSMS中运行

Running in visual studio and SSMS

分离将表加载到不同的任务中

Separating the load of the table into different tasks

增加插入数据的列的大小

Increasing the size of the columns that the data is inserted into

将延迟验证设置为false

Setting delay validation to false

记录中的最后一行：

推荐答案

你可以使用
数据查看器分析数据步骤。

这篇关于SSIS数据流任务挂起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！