SSIS: Insufficient disk space

Question

Post reply

SSIS: Insufficient disk space

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

arooj300 (8/28/2014)
Hi Koen,
I have written query, and selected only the key column but still the problem is same.

How big is the lookup table? What data type does the key have?

How much RAM does the machine have?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

arooj300 Hall of Fame Points: 3433 More actions · Answer 2

Lookup table having 12 million records. we have 16 Gb of RAM.

We have five key columns , four are having data type int and one column is having nvarchar(50).

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

That's a bit over 1.6GB of memory you need to cache the lookup.

Maybe it's an issue when you run the package in 32-bit?

What if you execute the package in 64-bit?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

arooj300 Hall of Fame Points: 3433 More actions · Answer 4

I executed package in 64-bit only. I also tried with 32-bit , but issue is remain same.

angela_trapp SSC Enthusiast Points: 102 More actions · Answer 5

Hello!

Did you ever figure out the solution to this? I have the same exact problem...12 million rows in the lookup. Select is on 4 columns, an int and 3 varchars.

Getting error: A buffer could not be locked. The system is out of memory or the buffer manager has reached its quota.

Thanks for any assistance you can offer.

robert_lot Newbie Points: 1 More actions · Answer 6

Hi,

I have the same problem. Do you find any solution?

Thanks