Loading data from Excel AcquireConnection Error

[Excel Source [108]] 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.

 

Ever seen the above error when trying to load data from an excel sheet into and SQL table while using BIDS or SQL Server Data tools.

Then here is the answer if you’re using a 64 bit system

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7b8c8aa7-30dc-4047-a4e3-3328c11fcd1e

 

Change the Run64BitRuntime to False and your good to go.