0

I am using VS2012 and creating a package on a 64bit machine to import some data from a .xlsx file. My question is that I am getting an error for the Excel connection manager, do I need to install some kind of excel driver or excel itself on the machine in order to be able to import the data?

The error is

Could not retrieve the table information for the connection manager 'Excel Connection Manager'. Failed to connect to the source using the connection manager.

Thanks

Improve this question

2 Answers 2

Reset to default
3

You'll need to configure SSIS to run in 32-bit runtime as Excel does not support 64-bit

Go to the Property page for the Solution, select Debugging and change Run64BitRuntime to False

Running 32-bit SSIS in a 64-bit Environment

Improve this answer
1

I have actually fixed this now by installing the 32-bit ACE OLE DB provider

Thanks

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.