Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xiaoyu
Starting Member
2 Posts |
 Posted - 2010-01-14 : 22:28:25
|
| I tried transfer data from 2 diferrent database which restore in 2 different server. In the beginning, I can transfer some data. After I do the process many times, I can't transfer any data. When I transfer, I always get this error message shown below. I hope someone can advice for my problem? Thanks. - Executing (Error) Messages * Information 0x4004800d: Data Flow Task: The buffer manager failed a memory allocation call for 10485760 bytes, but was unable to swap out any buffers to relieve memory pressure. 2 buffers were considered and 2 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. (SQL Server Import and Export Wizard) * Error 0xc0047012: Data Flow Task: A buffer failed while allocating 10485760 bytes. (SQL Server Import and Export Wizard) * Error 0xc0047011: Data Flow Task: The system reports 71 percent memory load. There are 3487420416 bytes of physical memory with 1001398272 bytes free. There are 2147352576 bytes of virtual memory with 72638464 bytes free. The paging file has 7524519936 bytes with 4705587200 bytes free. (SQL Server Import and Export Wizard) * Error 0xc02020c4: Data Flow Task: The attempt to add a row to the Data Flow task buffer failed with error code 0x8007000E. (SQL Server Import and Export Wizard) * Error 0xc0047038: Data Flow Task: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - Query" (1) returned error code 0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard) * Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. (SQL Server Import and Export Wizard) * Error 0xc0047039: Data Flow Task: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled. (SQL Server Import and Export Wizard) * Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited. (SQL Server Import and Export Wizard) |
|
|
shan
Yak Posting Veteran
84 Posts |
Posted - 2010-01-15 : 16:01:23
|
| Try loading in batches and commit them , Look at "Row per batch" setting and "Maximum insert commit" in your destination and give some values (like batches of 50,000) and see if it works. Looks like memory is getting full-Shan |
 |
|
|
xiaoyu
Starting Member
2 Posts |
Posted - 2010-01-18 : 22:41:11
|
| I already try this method. To send by batch. But I am still have the same problem. Is there any others way to solve my problem. Thanks. |
|
|
|
Cedar72
Starting Member
1 Post |
Posted - 2010-01-20 : 13:56:40
|
| I am having this same issue, the package had run fine for a few days and now I am getting the error:Information: The buffer manager failed a memory allocation call for 10485760 bytes, but was unable to swap out any buffers to relieve memory pressure. 2 buffers were considered and 1 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. |
|
|
|
|
|
|
|
|
Import and Export Table from 2 different server