Big size excel upload issue in asp.net by SSIS package.

Question

3.00/5 (2 votes)

See more:

Hi All,

I am uploading excel file in asp.net by using ssis package. if excel file size is small then that upload working fine but if excel file have big data (i.e. 30 mb) then data not upload and in ssis log "System resource exceeded." message is display.

When i run my application from webserver then upload fine but when i configure application in IIS then only i am facing above issue.

My application Details
ASP.net 4.0
SSIS 2008
SQL server 2008 R2

Please help!!!

Posted 13-Jan-14 0:49am

jangid82

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Cenarjun · Answer 1 · 2014-01-13T01:49:00

Solution 1

increase the runtime of IIS..by default it will be 9...Increase it and add the below line in your web.config

<pre lang="c#">< httpruntime maxrequestlength="2097151" executiontimeout="900000" usefullyqualifiedredirecturl="false" minfreethreads="8" minlocalrequestfreethreads="4" apprequestqueuelimit="100" />

You can upload upto 1 GB in SSIS

Posted 13-Jan-14 1:49am

Cenarjun

Updated 13-Jan-14 1:50am

v2

Comments

jangid82 14-Jan-14 6:17am

Dear Cenarjun,

Thanks for prompt solution but i am facing still same issue after changes as per your solution. In my application side SSIS package executed successfully no error found but in my database ssis package log still same "System resource exceeded."

I have also check application system event viewer. in this i got two stages-
1. Package "" started.
2. Package "" finished successfully.

it take only 8 seconds for execution.

Please help me

Cenarjun 14-Jan-14 7:38am

Sounds like you have a memory leak. Are you making sure to close and dispose of database connections?

jangid82 14-Jan-14 8:41am

Dear Cenarjan,

If i using application by webserver ( port ) direct run then upload successfully but i am facing this issue only when i hosted application in iis.

Cenarjun 15-Jan-14 0:57am

increase the timeout period in IIS...