今天SSIS导Excel数据的时候遇到下面的错误:
[Connectionmanager "Excel Connection Manager"] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The ExcelConnection Manager is not supported in the 64-bit version of SSIS, as no OLE DBprovider is available.
解决办法:VS使用32位运行环境
打开BIDS: Project Properties -> Debugging -> Run64BitRuntime = False