SSIS:SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Error code 0xC020801C,0xC0209303

The error info:

[Excel Destination [20]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

[SSIS.Pipeline] Error: Excel Destination failed validation and returned error code 0xC020801C.

 

The solution:

1.单击解决方案中的Project,

2.在项目属性窗体中做如下操作

2.