System Out of Memory exception? Having this error when I try to use many functions for an import

The situation is that I can import a file successfully. But when i add data to different tables thru 开发者_StackOverflowfunctions I get this error. Are their ways to solve this problem. Since Ive seen in other forums that it is a performance/memory issue. But the server has almost 8GB of ram.

what can be the solution to this?

Is this a 32 bit or 64 bit application? If it is a 32 bit application, you can't access more than 2 GB per default. If it is a 32 bit, large address aware application on 64 bit you can address 4 GB.

For additional info please see this question Maximum .NET achievable memory?