English 中文(简体)
是否有办法放松对国王软管的控制?
原标题:Is There a Way to Slowdown Running of Kingswaysoft?

I m试图从Kall数据库向动态数据表365输入255个数据流。 虽然国王韦软公司通常运行一个记录第二个记录,但这种情况破坏了动态与遗产制度之间的一体化。

不幸的是,我完全不能阻止一体化,而不要错失。 这是一种可能性,但鉴于这是一个实际用户目前使用的联接系统,我更喜欢使用。

我尝试增加一个包含以下法典的内容:

public override async void Input0_ProcessInputRow(Input0Buffer Row)
{
    Thread.Sleep(5000);
}

这样做是为了尝试并限制每5秒一行,但似乎只是搁置<代码>。 用户群Inner Join和 构成部分在到达汇之前的步骤。

My batching/multithreading settings in the CRM Destination Source are as follows: Batching/Multithreading settings

我已经把多面连接起来,把批量缩小到一起。

我能否以另一种方式减缓这一下降?

EDIT: The entire data flow looks like this SSIS Dataflow

问题回答

这不是最有效的解决办法,但你可以尝试利用任务和每个集装箱向光盘目的地发送请求书,而不是一个包含源头和目的地的数据流。 这样,你至少会有更多的时间来控制各种要求,在包含光盘目的地的数据流任务上游睡觉。 希望这一帮助。





相关问题
Transform date represented as String to Date in Visual Basic

I am using SSIS and I need to transform a date. How can I transform a date in String format (e.g. 14/09/1980) to the same but in date format in VB.NET? I would like the datetime format to insert it ...

SSIS Script Task connecting to AD

I have written a SSIS 2005 script task that connects to Active Directory and reads user accountnames to store in database. I was able to successfully test this on my local system by executing dtexec....

ssis sql server 2008 for access .mdb database

I want to know how to import .mdb (MS Office 07) file into Sql server 2008 by SSIS. I need to run this ETL packet in such a way that it checks for duplicates, and if any doesnt re-insert them, but ...

parent package in SSIS

I need to execute 29 ssis packages. So planning to create one master package which will execute all these packages. I don t know how to implement this. Can you please explain in brief. Thanks in ...

SQL Agent not kicking off an SSIS package

I have a server that has a SQL Agent job setup to run a two part datawarehouse build and Analysis Services cube build. The job ran successfully until there was a problem with Management Studio and ....

Can SSIS ScriptTask References resolve to a non GAC location?

In SSIS 2008, the ability to reference other class libraries has been added. Is there anyway to resolve the references to a non-GAC location when deployed to a non-developer environment? For instance, ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签