JoshuaT,
You can refer below link on how to convert spreadsheet to new format.. This script will go in script task.
http://blog.quasarinc.com/ssis/save-as-a-new-excel-file-in-ssis-2012-script-task-using-visual-basic/
You can use variable to read the file name and check if filename has extension as .xls then execute above script task else skip this script task..
:rolleyes: