執行SSIS出現一個很奇怪的問題，Error: A buffer could not be locked

最新推荐文章于 2021-04-10 01:21:25 发布

原创最新推荐文章于 2021-04-10 01:21:25 发布 · 482 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ssis #buffer #manager #system

商业智能BI 专栏收录该内容

58 篇文章

订阅专栏

本文記錄了一次使用SSIS（SQL Server Integration Services）過程中出現的錯誤代碼DTS_E_PROCESSINPUTFAILED，詳細描述了錯誤發生在庫存交易InventoryTransDtl（獲取首次入倉日期）組件上的情況，並提供了系統返回的錯誤代碼0xC020204B，該錯誤涉及內存鎖定失敗及可能的內存不足問題。

[庫存交易InventoryTransDtl（獲取首次入倉日期） [141]]
Error: A buffer could not be locked.
The system is out of memory or the buffer manager has reached its quota.

[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "庫存交易InventoryTransDtl（獲取首次入倉日期）"
(141) failed with error code 0xC020204B.
The identified component returned an error from the ProcessInput method.
The error is specific to the component,
but the error is fatal and will cause the Data Flow task to stop running.
There may be error messages posted before this with more information about the failure.