SSIS 32bits on Windows 2008 64bits

Discussion in 'microsoft.public.sqlserver.dts' started by Landry, Jun 11, 2010.

  1. Landry

    Landry Guest

    trying to run an SSIS package (SQL 2008) using the 32bit DTEXEC (due to
    32bit Oracle client) on Windows 2008 64bit with 64GB of RAM. The package
    fails with memory error, indicating lack of memory, 2.4Gb are needed to run
    the package and the system does not have this available!
    The same SSIS package (SQL 2005) runs smoothly on Windows 2003 32bits with
    4GB of RAM (/ 3GB switch in BOOT.INI).
    I tried using the / 3GB switch in Windows 2008 64bit (Bcdedit.exe / Set
    IncreaseUserVa 2970) and did not work.

    Thanks for help,
    Landry, Jun 11, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.