CODEWITHSUNDEEP
ssisdynamics-crmkingswaysoft
B.Griffin
B.Griffin

Reputation: 353

Is There a Way to Slowdown Running of Kingswaysoft?

I'm trying to input 255 rows of data from a SQL Database to a Dynamics 365 Dataverse table. While it would normally be great that Kingswaysoft runs at one record a second, this crashes the integration which goes between Dynamics and a Legacy system.

Unfortunately, there is no way I can stop the integration from crashing short of turning it off. This is a possibility, but as this is a LIVE system currently being used by real users, I'd prefer not to.

I've tried adding a Script Component with the following code:

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

This was to try and limit the running to one row every 5 seconds, but it just seemed to hold up the ClientGroup Inner Join and Script Component steps before reaching the sink.

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

I've already set multithreading to off, and the batch size to one.

Is there another way I can slow this down?

EDIT: The entire data flow looks like this SSIS Dataflow

Upvotes: 1

Views: 142

Answers (1)

Marvin Cox
Marvin Cox

Reputation: 1

Not the most efficient solution, but you could try sending the requests to the CDS destination using tasks and a for each loop container instead of a single dataflow containing source and destination. That way you would at least have more control over the time between requests by sleeping thread in a script task upstream from the data flow task that contains the CDS destination. Hope this helps.

Upvotes: 0

Related Questions