SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. error code 0xC0202009

[你好布布]

Message
Started: 1:06:23 AM Error: 2013-03-19 01:45:32.84 Code: 0xC002F304 Source: Send Mail Of SCTM Sync failure Send Mail Task Description: An error occurred with the following error message: "The specified string is not in the form required for a subject.". End Error

Error: 2013-03-19 01:45:32.86 Code: 0xC0202009 Source: Copy Test Cases To Local OLE DB Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". End Error

Error: 2013-03-19 01:45:32.89 Code: 0xC0047038 Source: Copy Test Cases To Local SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. 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. End Error DTExec: The package execution returned DTSER_FAILURE (1).

Started: 1:06:23 AM Finished: 1:45:41 AM Elapsed: 2357.61 seconds. The package execution failed. The step failed.

偶尔会出现这个错误，不知道为什么？

[KevinLiu]

看到了deadlock错误

[KevinLiu]

所以你的ssis被当作牺牲者kill 掉了

[你好布布]

找到了如何解决deadlock 的方法，在sql server configuration manager 里设置了startup parameters 后，到目前没有出现过这个问题.

[lk37926]

您好,我也遇到您在SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. error code 0xC0202009 贴中所描述的问题,ssis偶尔组件出现deadlock的情况.想请问一下您所说的 "找到了如何解决deadlock 的方法，在sql server configuration manager 里设置了startup parameters 后，到目前没有出现过这个问题." 具体是在哪里设置呢?如能得到您的回复 我将万分感激