您好，请检查以下链接。这可能对你有帮助。



http://denglishbi.wordpress.com/2009/03/29/ssis-2008-ado-net-source-issue-with-ssas-data-源错误码0x80004002 /

Hi everyone,

i am new to ssis, i am Reading the data from database and saving in excel. when am running first time the data is writing to excel.for 2 time i am getting the below error.after that again i am disconnecting the ado net source and again am giving ado net source.please help me how to reslove this issue.


[SSIS.Pipeline] Error: component "ADO NET Source" (4292) failed the post-execute phase and returned error code 0x80004002.

[SSIS.Pipeline] Error: component "ADO NET Source" (4292) failed the cleanup phase and returned error code 0x80004002.

Hi, Please check below link. This might help you.

http://denglishbi.wordpress.com/2009/03/29/ssis-2008-ado-net-source-issue-with-ssas-data-source-error-code-0x80004002/