The .ods or OpenDocument Spreadsheet can be opened with Excel 2007 or later, OpenOffice and LibreOffice.
It contains multiple files within a zip file, one way of importing is to rename it as .zip, extract the content.xml part and feed it to the SSIS.
😎