I am not very experienced so please bear with me.

I have been attempting to import a 2500 MB and 3800 MB CSV into SQL Server 2016. Unfortunately I keep getting the System.OutOfMemoryException error. My computer has 8.00 GB RAM so I figured I would just increase the max server memory from the default up to 4000 MB. For some reason though each time I try to change the max server memory to make it higher it changes back to default the moment I press OK. How do I fix this problem?

I am using `BULK INSERT` to import the data. The `BATCHSIZE`, `KILOBYTES_PER_BATCH`, and `ROW_PER_BATCH` arguments are not set.

**UPDATE**

I have decided to split up my CSV document so that I can import less of it at a time. Unfortunately by the time I try to import the last piece of my CSV the error shows up again.

**UPDATE**

I have managed to substantially increase the max server memory to 4 GB. However this has not fixed the problem.