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
No comments:
Post a Comment