SSIS Error - Excel Connection - Class not registered
Connection manager "Excel Connection Manager" Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Trying to read an excel file and getting a connection problem. The interesting thing is if I go to query analyzer and use sql code to read the excel file I have no issues. It just does not work via SSIS. Any ideas.