Error No.1
[Connection manager "Excel Connection Manager
1"] Error: SSIS Error Code 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.
Solution -
Right click on your project .. go to properties and then small window will pop up in that window look for " Debugging" click on Debugging then you see you on your right pane under Debug options ---> Run 64bit Runtime as False
