SSIS - 限制并发连接 [英] SSIS - Limiting Concurrent Connections

问题描述

我使用 SSIS 连接到旧式大型机数据库，这一次只允许 5 个并发连接.我有一个要传输许多表的数据流任务，由于此限制，它被踢出局.我已将数据流任务拆分为单独的数据流，目前正在运行，但这不是最佳选择，因为它们需要排序，并且流中的 1 次大传输会阻止后续传输.任何人都知道如何限制单个数据流中的连接数，我曾尝试使用引擎线程，但这没有任何区别.

I am using SSIS to connect to a legecy mainframe database and this allows only 5 concurrent connections at a time. I have a dataflow task with many tables to transfer and it kicks outs because of this limitation. I have split up the Data Flow task into seperate data flows and this is working for the moment, but it is not optiomal as they need to be sequenced and 1 large transfer in a flow is holding up subsequent transfers. Anyone any idea of how to limit the number of connections in a single data flow, I had a look at using the Engine Threads but this did not make any difference.

任何帮助都非常有用.

推荐答案

您用于任务的连接对象应该有一个名为RetainSameConnection"的属性.这应该会导致在所有任务中使用相同的连接.至少对于 OLEDB 连接类型是这样.我不知道 ADO.NET 连接是否具有相同的属性.他们可能会.

The connection object you are using for your tasks should have a property named 'RetainSameConnection'. This should cause the same connection to be used across all tasks. At least this is true for OLEDB connection types. I don't know if ADO.NET connections have the same property. They probably do.

这里有一篇文章了解更多信息<代码>:http://munishbansal.wordpress.com/2009/04/01/how-to-retain-same-data-connection-across-multiple-tasks-in-ssis/

Here is an article for more information: http://munishbansal.wordpress.com/2009/04/01/how-to-retain-same-data-connection-across-multiple-tasks-in-ssis/

这篇关于SSIS - 限制并发连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！