April 24, 2024

SamTech 365

PowerPlatform, Power Apps, Power Automate, PVA, SharePoint, C#, .Net, SQL, Azure News, Tips ….etc

SSIS ERROR – The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available

Screenshot 2015-10-06 18.28.36

In order to fix the import issue from Excel file in a 64Bits environment using SSIS, just click project properties and turn the Run64BitRunTime to False.

 

Good luck guys

Screenshot 2015-10-06 18.28.36

In order to fix the import issue from Excel file in a 64Bits environment using SSIS, just click project properties and turn the Run64BitRunTime to False.

 

Good luck guys