I'm trying to import around 5M records from a SQL Server database to an Oracle Database and am getting an Out of Memory
error. See details below. I've tried a number of recommendations already from researching, but haven't found a solution.
Things I've tried/Notes:
Any ideas?
Here are the pertinent messages.
Warning: 0x80047076 at Data Flow Task Load PFILSA OneLink Table 2012, SSIS.Pipeline: The output column "DateTime" (137) on output "OLE DB Source Output" (105) and component "OLE DB Source" (94) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Error: 0xC0202009 at Data Flow Task Load PFILSA OneLink Table 2012, OLE DB Destination [12]: 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.".
Your package is trying to read too much data into memory than what your machine can handle before inserting into your destination. Open the destination and set it use fast-load data access mode, set rows per batch to 10000 and maximum insert commit size to 100000
User contributions licensed under CC BY-SA 3.0