Quick Hit: Using XLSM Files With SSIS

If you've tried to use an Excel 2010 XLSM file - a "macro-enabled" spreadsheet - with Integration Services, you'll have seen the incorrect (and badly worded) message that the "File path contains invalid Excel file.  Please provide file with .xls or .xlsx extension."  It looks like the SSIS team just didn't know that Excel makes other flavours of files.
How Do You Get Around This Limitation?

1. Create an Excel Connection Manager to refer to ANY other spreadsheet with a "valid" XLS or XLSX extension.  (You don't have to save your XLSM file "as" an XLSX.)
2. Select the Excel Connection Manager in your Connection Managers pane.
3. Open the Properties Window (F4).
4. Change the "Server Name" property to the full pathname of your XLSM file.

Done!