I dig the new look, the only problem is that - for me anyway - since the change the site seems to be really, really slow at times.  Especially navigating...

Kinda what I figured...  but nice to have confirmation 😀

They do have access to the production server to read and write from various databases - but it isn't global.

That being...

You can start here:
https://www.mssqltips.com/sqlservertip/4165/how-to-read-data-from-multiple-excel-files-with-sql-server-integration-services/
This will show you how to create a loop that will look into a folder and import the file(s) it finds in that folder...

Your best bet is to create a separate data source and destination in SSIS for each Excel file.  Populate two staging tables, and then combine them in SQL either by...

If you're using SQL Server then LISTAGG isn't going to work because that's an Oracle function.

If you're using SQL Server 2017 or Azure, I think you can use...

Eddie --

I was under the impression that you could only restore to a higher level if you were in recovery mode...  ours all need to be in standby...

Go into report properties and make sure the width and height properties are set correctly to the page size you want...  and make sure that you account for your margins. ...