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

Solution: 

Right click on the Solution and go to Properties as shown below
In the Configuration Properties select the debugging tab 





0 comments:

Post a Comment