I am exporting about 14 Million records from SQL2005 to Oracle (8). I am using the Microsfot OLE DB Oracle connection is SSIS. The job has failed on me about 3 different times. I get up to about 7-8 million and then start getting Virtual Memory errors and the job ends. I've arleady modifed the Buffer (DefaultBufferMaxRow and DefualtBufferSize) Paramenters and the BufferTempStoragePath to a drive with over 50gb:, but still get the errors.
Does anybody have any recommendations on running a big job like this. I have about 2 gigs of physical ram and 2 gigs of virtual memory.
Does anybody know of a way to import the records 1-7000000 and then 7000000-14000000?
[DTS.Pipeline] Information: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 16 buffers were considered and 16 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.
[Destination - TPA_FEE_SCHED [58]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007000E. An OLE DB record is available. Source: "Microsoft Cursor Engine" Hresult: 0x8007000E Description: "Out of memory.".
Start Free Trial
