Error out of memory when importing flat file SQL-Server

Question

Error out of memory when importing flat file SQL-Server

Donald Trung 1

I am importing flat file (both txt and csv) into SQL Server. Such file has more 1.7 mil rows. When importing, has error like screenshot below. Pls kindly share how to solve this. Much appreciated !

Seeya Xi-MSFT 16,586 Reputation points

2023-01-04T08:43:19.057+00:00

Hi @Donald Trung ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Seeya Xi-MSFT 16,586 Reputation points

2023-01-18T02:35:50.6466667+00:00

Hi @Donald Trung ,

In order to benefit all community members who are having this similar issue, please choose an answer to accept for the answer you think is useful to you. Your contribution is highly appreciated.

Best regards,

Seeya

1 answer

Your answer

Seeya Xi-MSFT 16,586 Reputation points

2023-01-04T08:43:19.057+00:00

Hi @Donald Trung ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Best regards,
Seeya
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Seeya Xi-MSFT 16,586 Reputation points

2023-01-18T02:35:50.6466667+00:00

Hi @Donald Trung ,

In order to benefit all community members who are having this similar issue, please choose an answer to accept for the answer you think is useful to you. Your contribution is highly appreciated.

Best regards,

Seeya

Answer 1

Hi @Donald Trung ,

Welcome to Microsoft Q&A!

Exception of type 'System.OutOfMemoryException' was thrown

This error indicates that Management Studio is running out of memory, not the SQL Server service. Even if you installed 64-bit SQL Server, the SQL Server Management Studio executable is a 32-bit application. Therefore, it is limited to 2 GB of memory.
Please refer to this document: Exception when you execute a query in SQL Server Management Studio
Here is a method you can take:
Use sqlcmd Utility instead of SSMS to run the SQL queries. This method enables queries to be run without the resources that are required by the SSMS UI. Additionally, you can use the 64-bit version of Sqlcmd.exe to avoid the memory restriction that affects the 32-bit SSMS process.

Best regards,
Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Error out of memory when importing flat file SQL-Server

1 answer

Your answer