If you're trying to generate a dynamic SQL command to return rowcounts for every table, this would work.
DECLARE @sql NVARCHAR(MAX) = STUFF((
        SELECT CONCAT(' UNION ALL SELECT...

Simplistic answer for Question 3: Import CSV data into data warehouse.
Import the CSV file into a staging table.
For each dimension:
     Find all new dimension values in...

Are any of the new tempdb data files on a different disk?  Too much data to fit on the disk is still going to be too big when split into...

You could use  "INSERT INTO ... SELECT NULLIF(a, ''), NULLIF(b, ''), ... FROM OPENQUERY()"  to convert empty strings to NULL.

You have to add the day number, or however you define your 24-hour periods, to the PARTITION BY clause. Then you will get a row 1 for every widget ID...

If the stored procedure exists on server A, the EXEC statement must refer to where it is stored.

"EXEC dbo.[Test]" when connected to the same database.
"EXEC master.dbo.[Test]" when...

I have been lucky to work for companies that had very enjoyable parties, even though I'm more of an introvert.

My first job back in the 80's had some...

If you're building these queries dynamically, " QUOTENAME(Description, '''') " puts quotes around a string and doubles any embedded quotes.  Or " QUOTENAME(Description, CHAR(39)) " if you don't like the four-apostrophe literal.

The SSISConfiguration.sql attachment on the original article should be all you need.  You don't say what's not...

I think these schemas are historical artifacts.  These security roles were part of SQL back at least to version 6.0.  To be a role, they also had to be defined...

This is an approach that worked well with SQL 2005 and 2008, maybe through 2012.  But with SQL 2016 you're better off using package variables that are set by project...

In case there were other databases on the server that did not have the target table, I thought it would be nice to include a filter for only the databases...

I would not be afraid of using a trigger to capture all event info you need (primary key, new column value, time, user login).  Your description makes it clear that...

If nothing inside the For Each File container is logging any progress, the most likely explanation is that it isn't finding any files.

You can get more details by...

Older Management Studio versions can connect to newer servers and run queries.  You could probably even get SQL 2000 Query Analyzer to connect and run a query on SQL 2016....