Forum Discussion
SSIS Excel Connection Manager error
I'm having issues with excel destination in my SSIS package. I'm using a conditional split to send data to a spread sheet from OLE DB source. I feel the issue is because of the version of excel SSIS...
Based on the last error message I would say it is a 64-bit vs. 32-bit issue. SSIS is probably one and Office 365 is the other. I am not sure which is which in your case. The remedy is to download the missing Microsoft Engine redistributable.
https://www.microsoft.com/en-us/download/details.aspx?id=54920
If SSIS is 64-bit but Office 365 is 32-bit then you need to install the 64-bit version.
If Office 365 is 64-bit but SSIS is 32-bit then you need to install the 32-bit version.
https://www.microsoft.com/en-us/download/details.aspx?id=54920
If SSIS is 64-bit but Office 365 is 32-bit then you need to install the 64-bit version.
If Office 365 is 64-bit but SSIS is 32-bit then you need to install the 32-bit version.
Thank you for your response. I downloaded ME but still getting the same issue along with a new dialog box in the connection manager. The box pops up right after i attach the excel file to the connection manager. It reads, "Could not retrieve the table information for the connection manager 'Excel Connection Manager'. Failed to connect to the source using the connection manager 'Excel Connection Manager' "