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

I have a 64bit system and installed SSIS on my system. I encounter with this error when I was trying to transform excel record and write it in a flat file.

Solution :

1. Go to the Project properties [Right click on the project and select properties]

2. Select Debugging from the Configuration properties.

3. Made Run64BitRuntime  to False. Click OK.