Holy thread revival, Batman!

If you must use SSIS to do this, you can use an Execute SQL task to read the list of table names into an object variable.

Then use a...

Back to the OP, there seems to be some inconsistency in your data and desired results.

First you say that the week is Monday through Sunday.  This will create...

Depends on...

Check the "ExecuteOutOfProcess" property, which controls parallelism.  I found a reference in this blog: https://blog.sqlauthority.com/2015/02/12/sql-server-the-basics-of-the-execute-package-task-notes-from-the-field-067/
It doesn't specifically state, but I suspect that if Out Of Process is true, the...

And then you may have a name like Arthur Conan Doyle.  His given last name was Doyle, he was knighted under the name Doyle, but sometimes Conan Doyle is used...

I think we need more information on what you want to achieve here.

Eirikur's solution will give you exactly what you asked for.  But is that what you really...

It looks like you're trying to make the sum of rounded numbers equal the sum of unrounded numbers.  That won't work.  That's why poll results often say, "Totals may not...

An interesting question, but it could have been more interesting.
You could have added more values, so that the number of 3's and 5's was not equal - and the...