SSIS 2012 or 2008 Connection manager Excel Connection Manager Error SSIS Error Code
SSIS Error :
DTS_E_OLEDB_EXCEL_NOT_SUPPORTED The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
While executing a package an moving data from database to excel sheet I got this error .
so decided to provide the solution to this error.
This is just a small issue. Looking at this error for the first time I thought it is related to some driver or I need to update some settings
Right click on the Solution and go to Properties as shown below
In the Configuration Properties select the debugging tab