Buffer problems on data flow
From what I remember there were a couple problems in the ctp's with buffer allocation errors. We seem to be seeing a similar error on 2005 x64 when we create a large number of sources and destinations within one dataflow task (something more than around 15 of each). Basically all we are doing is copying tables from one db to another. The computer will lock after about a million rows with a ton of the following messages:
The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 124 buffers were considered and 124 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked.
We have 4 gigs of ram on that server so I'm not sure what's wrong with this.
