'SSIS Foreach Loop Container to read files and load into Dynamic 365 causes VS2019 geting crashed

I'm trying to load records from CRM 2011 (on-premise) to Dynamic 365 using foreach loop container. After a while (sometime after 15 k records another time after 19k or 17 k records from a total of 71k records) Visual Studio crashes and then restarts. I have to kill the debug task in the task manager for the next execution of the package.

My package looks like this:

my SSIS package

First I load all the records for Foreach loop task into a Recordset destination and save all the records in a variable ID_narocila_iz_dodatni_naslovi.

Recordset Destination

Then I use this variable in Fooreach ADO Enumerator.

Foreachloop - Collection

Foreachloop - Variable Mappings

Foreachloop - Expressions

I can't figure out what is wrong here. Any help would be appreciated! Thanks!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source