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

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...

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

1 solution

Solution 1

Add your solution here

Preview 0

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

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us