Bulk insert using sql server, asp.net

Question

I need to insert the bulk data into MS SQLServer (approximately 2lac records) from excel or csv format file using asp.net C# web application.

My problem :

It throws out of memory exception.

So, I need to fix the issue from asp.net but NOT THROUGH SQLSERVER.

When I tried the bulk data insert/Update at the SQLServer it works fine. But when I tried to do the same process using the ASP.NET the system throws "Out of Memory Exception"

Kindly help me to solve this problem.

Thanks Vadivelu

How are you uploading the excel / csv file in the first place? I presume that a xls / csv file with 200,000 records could potentially be quite big in size depending on the individual size of each record — Jagmag
– Jagmag, Commented Jan 29, 2011 at 18:01

Anthony Pegram · Accepted Answer · 2011-12-22 03:03:45Z

2

See some resources:

edited Dec 22, 2011 at 3:03

Anthony Pegram

128k28 gold badges229 silver badges252 bronze badges

answered Jan 29, 2011 at 19:02

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Bulk insert using sql server, asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related