When we are using the excel source in SSIS in a 64 bits compute. We are getting below error.
[Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 1" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
By default value of Run64bitRunTime is true.
Let’s see how to set the Run64bitRunTime properties as false.
Right click on solution and select property
Go to Debugging
Set the Run64BitRunTime as false. See below.
Click on apply and click ok.
Now I am running this package.
Package executed successfully.
