I found the solution. I initially defined the file name variable without a default value. This did not give any errors, but apparently caused the Excel Source to fail every time I opened its editor to make any edits. My guess is that the Excel Source was trying to open a valid Excel file even just to configure the package. The fact that the variable was being assigned properly during runtime was not good enough.