Good morning from my home office. Hope all is well.
I have successfully configured the ODBC connection using iSeries something or other and created the data source in SSIS and all of that is working great, including some transformations. My job seems to fail when doing the load. It is going to a SQL server instance where I duplicated this particular table. The original contains 1.6 million records. I get this error (probably familiar to some) when I run this within BIDS: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 0 buffers were considered and 0 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.
The SQL server does have 32GB memory, but is a shared SQL instance. Thanks for any advice on this. Maybe there is a way to stage migration of the data in chunks? Or some configuration I missed.
- This topic was modified 6 months, 1 week ago by Brad Allison.