Internal error (Exception of type 'System.OutOfMemoryException' was thrown.) in ProcessInput adding rows to cache

Topics: Issues 3: Executing the Component (Run-Time), Possible Bugs/Missing Features?, Questions About the Code or Project
Mar 15, 2011 at 9:32 AM

Detailed error is at: MouldingAndMillWork.SSIS.KimballmethodSCD.ProcessInput () method.

Package Details:

DTSX package tries to transfer rows from Oracle to SQL.

Some conversion on columns are done before passing values to Kimball Component.

Number of Rows to transfer ~ :10000.

Amount of RAM : 48GB (Server machine where its deployed)

Still its showing  Out of Memory Exception!!

I checked the process in Windows and the process is (DTEXecUTil) is just 35% at that level when error occured.

Warnings inside the component:

Possible truncation of a column  (length : 50 in destination 100 in source)

Please help me resolve this issue.

Thanks and Regards,




Apr 8, 2011 at 6:54 PM

Is this a 32-bit process?  Or a 64-bit SSIS execution?

How "wide" are the rows?

If you watch Task Manager, what's the peak memory consumption (in bytes) for DTExec that you see?