SSIS: Insufficient disk space

  • 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

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

  • 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

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

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

  • Hi,

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

    Thanks

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

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