The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
Error Message:
[Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Solution 1:
1. Navigate to Project-> project Properties.
2. Navigate to “Debugging” option from left panel and from Right panel, change Run64BitRuntime value to false.
Solution 2:
1. Navigate to Project-> project Properties.
2. noticed that the package has "DelayValidation" property set to false in the package.
So, we changed the DelayValidation property of package to true and re-ran the package and it succeeded.
[Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Solution 1:
1. Navigate to Project-> project Properties.
2. Navigate to “Debugging” option from left panel and from Right panel, change Run64BitRuntime value to false.
Solution 2:
1. Navigate to Project-> project Properties.
2. noticed that the package has "DelayValidation" property set to false in the package.
So, we changed the DelayValidation property of package to true and re-ran the package and it succeeded.
Thanks for your feedback
ReplyDeleteThank For sharing Valuable Information
ReplyDeleteMsbi Training Online
Msbi Developer Course
Thanks for your feedback
DeleteThanks for your information. very good article.
ReplyDeleteMsbi Training
Msbi Online Course