If you would like a coded solution, please present your sample data in the form of CREATE TABLE/INSERT statements.

I've seen that behaviour too.

This could start a flame war! I've seen instances of otherwise-seasoned coders on here using the dreaded

;WITH CTE AS...

So, I could use some help on this one: To Drop or Not to Drop (the temp table question) – SQLServerCentral Forums

I've tried Googling it but not finding...

Hello @ScottPletcher and @SSC Guru I am really sorry to say but don't even know how to do it and also, I really thought that the way I've explained,...

And please post SQL code in a code block.

Nice solution, Jeff.

Copy the results of your PRINT @sql into a new SSMS window & work it out from there, it should be easy to spot.

I wrote an article a while ago which may be of interest. It shows how to decompose the DTSX XML into something usable.

https://www.sqlservercentral.com/articles/ssis-variable-and-parameter-analysis

Searching the dtsx files in source control is your best best. The package XML is encrypted in SSISDB, do don't waste your time on that.

Add the schema to your table-name list.

I would manually update the file from a folder, and this list of tables won't change. The alert will run daily maybe every x hours..

We had an issue where...

The standard trick is to import the header row as if it were data and then discard it in the data flow (use a Conditional Split to do this).

Also add...

Sorry, I've been doing this stuff for so many years that I have no idea about suitable training resources for you.

Sounds like triggers are your best bet. What sort of alert do you have in mind?

If a user modifies 5,000 rows, do you want 5,000 alerts generated?

If thousands of alerts...