SSIS 2012 2008 Connection manager Excel Connection Manager Error SSIS Error Code

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 


Post a Comment