All geek questions in one place

Running SSIS Package - Memory Problem!

While executing the SSIS package, I received the following errors:

The buffer manager failed a memory allocation call for 10484608 bytes, but was unable to swap out any buffers to relieve memory pressure. 20 buffers were considered and 20 were locked. Either not enough memory is available to the pipeline because not enough are installed, other processes were using it, or too many buffers are locked.

[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.

[DTS.Pipeline] Error: The Data Flow task failed to create a buffer to call PrimeOutput for output "XML Source 1" (91) on component "GeneralCongfigurations" (98). This error usually occurs due to an out-of-memory condition.

This occurs when trying to insert data into an SQL table from an XML file using <Script Component '.

How to solve it?

+3
source share
3 answers

The report said that SSIS uses 20 buffers, 10 MB each - about 200 MB together. This is not a very large amount of memory, even on a 1Gb machine you would not run out of memory.

, - . SQL Server - SQL SSIS , , SQL ( SQL Server), SSIS - 0,5 .

+4

. , Lookup , . .

0

I ran into the same problem. My XML source is about 2 MB. when I run the package, it started to issue this warning OutOfMomory. My server has about 8 GB of RAM. So these were memory problems. The current machine SQL server service took up about 6 GB of space. I can check this from task manager. Because my SSIS package package was connecting to the differences database, I did not want the current SQL Server service to work. Therefore, the moment I stopped this SQL SERVER service, my SSIS package completed successfully.

0
source

Source: https://habr.com/ru/post/1711569/

More articles:


All Articles