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.
I uploaded a photo of the new error. check below.
