September 10, 2008 at 4:41 am
Hi,
I´m having a major problem with my SSIS packages.
I am moving data from an SQLServer databases to an Oracle database using SSIS.
But I notice that the DTExec.exe process in Process Manager is growing +-1Mb/sec in consumption. If the table is large it just keeps on growing, filling upp the RAM and paging afterwards, once paging fills up, the job crashes.
Has anyone experienced this issue ? Is this a problem with the Ole DB Oracle Provider. I tried this on a 32 bit machine running sp1 of SQLServer and also on a 64-bit machine running sp2 of SQLServer. Both are 2003 Windows Servers.
Thanks,
Óskar Gunn.
September 10, 2008 at 5:24 am
If you turn on logging, you will be able to see which object ends up with a buffer overflow.
It is possible that writing to the oracle server is taking too long and all of your records are overflowing the input buffer of the destination component. It could also be any number of other components - a sort, for example will buffer every record so they take a lot of memory.
September 10, 2008 at 5:56 am
Ok I will try the logging feature, although I´m not sure exactly where to see the problem.
The load speed to the oracle server is about 30.000 rows per minute.
Now after 230.000 rows the DTexec.exe is at 200.000K in memory consumption. Wouldn´t you agree that that is a bit unusual ?
When I select from MSSql to a flat file the memory consumption is normal. It´s only when I move the rows to the oracle server that the memory increases, so yes the fact that it takes a long time to load through the oracle provider could be the reason.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply