Found the problem....  *sigh*

Our infrastructure team spun up a copy of our production environment, but forgot to update the firewall to prevent it from communicating outside itself.  So it updated...

We aren't using SSIS - we have a stored procedure that we call where we're doing basically this for each of about a dozen tables:

truncate table xfer_fact_booking
insert...

Steve -

Thanks!  All good points that I unfortunately forgot 😀

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...