在run ssis package时,报错
The buffer manager cannot extend the file "C:\Windos\SERVIC~2\NETWOR~1\AppData\Local\Temp\DTS{B4AD63C5-5B02-40A8-BD15-3ABBCD15409D}.tmp" to length 10479136 bytes. There was insufficient disk space.
原因是系统swap file问题
A swap file allows an operating system to use hard disk space to simulate extra memory. When the system runs low on memory, it swaps a section of RAM that an idle program is using onto the hard disk to free up memory for other programs. Then when you go back to the swapped out program, it changes places with another program in RAM. This causes a large amount of hard disk reading and writing that slows down your computer considerably.
This combination of RAM and swap files is known as virtual memory. The use of virtual memory allows your computer to run more programs than it could run in RAM alone.
The way swap files are implemented depends on the operating system. Some operating systems, like Windows, can be configured to use temporary swap files that they create when necessary. The disk space is then released when it is no longer needed. Other operating systems, like Linux and Unix, set aside a permanent swap space that reserves a certain portion of your hard disk.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12374161/viewspace-731520/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12374161/viewspace-731520/