Skip to Content
0
Former Member
Jun 25, 2009 at 03:09 PM

SSIS package on dual server installation question.

47 Views

We have two server installation: 32 bit application/web server, and 64 bit database server.

We have a number of packages that rebuild and process dimensions daily.

Recently one of them started to fail with a bunch of SSIS buffers and memory management errors, such as "buffer failed to allocate memory", "out of memory conditions" etc.

The log also has the following line: "The system reports 54 percent memory load. There are 3488870400 bytes of physical memory....", which means that this package uses 32bit app server's resources (64-bit database server has 32G of RAM). SSIS isn't running on app server.

Also if you run a package on appserver using SSIS excecution utility or from BIDS, it runs just fine. It fails only if run from BPC.

Any clues about how to fix it would be greatly appreciated.

Thanks,

Roman.