Click here to Skip to main content
15,892,927 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Dear All,

Configuration : ASP.NET, Sql Server 2008 R2, IIS 7.5, WIndows 7.
I am facing the below problem :

I have one Web-project(web application). In this, internally I have captured the EXCEL file whose size is 30MB and then it's data passes to the DTS Packages(Sql Server 2008).

CASES :
1) When I run this through visual studio then it works fine. All data gets updated in back-end.
2) When I run this through IIS by making the virtual directory and browsing though IIS only then it's not running properly. In Sql server I got the "System Resource Exceeded" text, in one of the data packages table value . In short it gives "System Resource Exceeded" while running through IIS.
3)But when I run this through IIS with the small data( with small size of EXCEL file) it's running and also data updated in backed properly.

Troubleshoot : I have done the troubleshooting with DCOMCONFIG for "IIS WARGM Admin Service" but no use.

Main issue is with 2nd point.
Please help me asap.

Thanks in advance.
Posted
Updated 9-Jan-14 6:09am
v2

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900