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 allows to choose in the connection manager window. I could be wrong. Other destinations like flat file or OLE DB are not giving issues. I recently upgraded Microsoft Office 365. Screen shots of error included here. Thank you for your help in advance.
3 Replies
- 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.I uploaded a photo of the new error. check below.
- 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' "
