SSIS : The AcquireConnection method call failed with error code 0xC0202009

You may get this SSIS error when you are using Excel connection in your package.

This error message does not provide any clue about actuall problem.

If system does not have 64bit excel driver to handle the excel file we will get this error.

becasue by default our MSBI try to run the package with 64bit drive provider and end up with error.

easiest way is to change the project property Run64BitRuntime to FALSE.

This solution does not work in Production where package is runs from scheduled job.

Note : I faced same error for other problem also, not easy to figure it out root cause easily always.

Happy coding....