Outstanding. Thank you VERY much for the time you've spent on this whether it may have been trivial or not, Eirikur. You obviously took some time to import that bad boy into a "flat" table.
Glad to see that it's as complex yet as "simple" as I thought it would be. The fun part will be when they add a month between March and the Total. Would that be "self realizing" or what that require a change to the package?
Doing the same using script tasks and/or script transformations is even simpler and often more robust if properly constructed.
Simplest of all is the ELT method of using the SSIS to import all columns as text into a staging table....
Absolutely agreed on the above and that's the point that I'm trying to drive home on someone.
--Jeff Moden
Change is inevitable... Change for the better is not.