MS SQL Server : System.OutOfMemoryException: Array dimensions exceeded supported range on dataset

Question

I am running ETL CDM Builder to convert about 2TB of data into CDMv5 format, but it is giving an error 'System.OutOfMemoryException: Array dimensions exceeded supported range'  at 'Chunks creation' step. How can I fix it?

Answer 1

If you have configuration file, add the following lines to it. Hopefully, it will fix the issue.

 <runtime>

    <gcAllowVeryLargeObjects enabled="true" />

 </runtime>