Just to share a test were I wanted to push Query Tool to high limits with CSV stuff. I have a csv file with 9,5 million lines containing all Dutch postal adresses and PostCodes. This file weighs a lightweight of 2,5 GB. I wanted to csv-parse it with Query Tool, then upload it to SQL Server, becaus…

Parsing big csv file raises itgenclr007: OutOfMemory

forums 18 mei 2022 om 15:59 3

Topic		Antwoorden	Weergaven
Verwerken XML-bestand geeft itgenclr007 - Application is using more memory than available Wiki invantive-sql , xmltable	0	353	16 mei 2022
Verwerking van zeer grote tekstbestanden in JSON-, NDJSON-, CSV- en XML-formaat in SQL Wiki xmltable , invantive-sql , ndjsontable , jsontable , csvtable	0	378	27 mei 2022
Processing very large text files in JSON, NDJSON, CSV and XML format in SQL Wiki (en) xmltable , invantive-sql , ndjsontable , jsontable , csvtable	0	577	27 mei 2022
System.OutOfMemoryException thrown on JSONTABLE with Twinfield BI-ON-Focus Vragen invantive-sql , bi-on-focus-powerbi-twinfield	13	1986	11 april 2024
CSV inlezen lukt niet voor gebruik in Sumatra Vragen invantive-sql , csvtable , sumatra	3	256	10 oktober 2023