SSIS - Batch execution in script task

202 Views Asked by At

I need to run a particular action in Dynamics 365 for every record that gets created in a entity. i'm able to do it via script component(in C#).

The problem is script component opens CRM connection, executes a action and closes the connection for every record from my input. Input to script component is a single column(result from fetchXML) containing the GUID's of record on which i need to run the action.

The way i'm doing now is to add the GUID of record in Input0_ProcessInputRow() method to a list and execute the respective action in a batch of 10 records in PostExecute().

I understand PostExecute() is usually used for cleanup things.

I'm looking for a better/clean way to do this?

0

There are 0 best solutions below