I have an SSIS package that just runs an SSIS script job written (not by me). This script then dynamically creates packets and runs them in streaming mode, controlling the active number of threads. This is started using the SQL agent. It captures data from an Attunity source from an Oracle 11g database.
When I look at the process in the task manager, I see that DTexec.exe is slowly consuming more and more memory. when it reaches about 250 MB, it fails. It often returns different errors every time, sometimes it even appears as a cancellation request from the SQL agent.
I reduced the maximum memory to give more OS, did not work.
This should not be a memToLeave problem, since it is 64 bits. I tried working through the command line, nothing.
Windows Server 2003 SQL 2008R2
I have so many problems with this, and I tried everything I could find on the Internet. Does anyone have any ideas? I am sure that I have left something here, so ask and I will find out for you.
source
share