Post reply

SSIS : "Not enough storage is available to complete this operation (0x8007000e)"

  • August 9, 2011 at 9:44 am

    #255131

    Hi,

    I am getting the following error message in my Data Flow when I run my SSIS package with more than 200,000 rows. I have LookUps and FuzzyLookUps in my Data Flow. I works fine with less than 200,000 records. Any ideas?

    Thanks

  • August 9, 2011 at 9:47 am

    #1366033

    hemani2000 (8/9/2011)

    Hi,

    I am getting the following error message when I run my SSIS package with more than 200,000 records to go through LookUps and FuzzyLookUps but it w

    A bit too terse - please elaborate.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • August 9, 2011 at 9:48 am

    #1366035

    I might suggest the sql error log to get a more precise idea of the problem. I'd be guessing at tempdb atm, but that's jsut a guess without a lot more details.

Viewing 3 posts - 1 through 2 (of 2 total)

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