I'd modify your script to write out the query you're sending to SQL Server to the console, then run that query in a query window in SSMS to see what the error is, but I'm guessing the syntax for handling multiple files is incorrect.