OpenRowSet() does not allow to use variables for its parameters. We have to either encapsulate the entire command into a string and SQL exec that or find another way. The first one is complicated as we loose the scope of our temporary table. Anyone has a better approach to resolve that issue?

The problem is that the interpreter for the Stored Procedure is very smart. It detects the name of the Excel file and will not compile if the file does not exist.