To connect to an .xlsb (or .xlsm) file, you must first set your Excel Connection Manager to point to any generic .xlsx file on your computer (create it if you have to), then go to the ExcelFilePath in the Properties window of the Excel Connection Manager and manually change the path to the location of the .xlsb file.