Facing "out of memory" issue while importing data from a .csv file to create Pivot Cache

Hi All,

I need a help on this issue which we are facing.

We are trying to create pivot cache from an external .csv file.

This works fine when the csv file is small (<500 mb).
But it given "out of memory" error for bigger .csv files(>~500 mb).

Attaching sample code for reference -

Please Login or Register  to view this content.

Is there a way we can solve this issue. If not what is the best way to create a pivot table for >4-5 millions records.

It will be great help if someone can put some helpful pointers.

Moderator Note:

Pls use code tags around your code next time as per forum rules.

Originally Posted by SeriousDeveloper

This works fine when the csv file is small (<500 mb).
But it given "out of memory" error for bigger .csv files(>~500 mb).

Why don't you go for PowerPivot?